Exporting data to access

I am looking for a way to export my information out of SQL 2000 to access.
I would like to have an exact replica of my SQL databases but in dbf format.
Is there a way to do a backup in SQL in DBF format? Is there a utility to
convert a SQL Backup to DBF.
Thank-you
If you want your database in access, why do you want it in
dbf format? Access uses mdb files.
You can't backup a SQL Server database to other database
platform formats. You can export the data to Access using
DTS. Another option is replication as Access can be a
subscriber to SQL Server publications. You can find more
info in books online under the topic Access Subscribers.
-Sue
On Tue, 24 Aug 2004 09:20:17 -0300, "kmd" <kmd@.hotmail.com>
wrote:

>I am looking for a way to export my information out of SQL 2000 to access.
>I would like to have an exact replica of my SQL databases but in dbf format.
>Is there a way to do a backup in SQL in DBF format? Is there a utility to
>convert a SQL Backup to DBF.
>Thank-you
>

Export with DTS to a dbf file

Hello,

I'm trying to export data from sql server2000 to a dbf file
When creating the dts package, i've got the following error (when creating the table in the dbf file):
"HResult of 2147467259 returned. Unexpected error occurred..."

The table i try to export is like:
Table1 (field1 int, field2 int...)

Does anyone have any idea?

Thanks in advance

IsabelleDo not forget that length of name field for DBF is only 10 ...
Check name of columns in your table.

export to dbf in SS2005

Is it possible to export to a dbase file (.dbf) in SQL Server 2005?
Thanks,
Dan D.
Yes: you should create a Connection Manager OLE-DB for ODBC and select the
ODBC for your .dbf files
Gilberto Zampatti
"Dan D." wrote:

> Is it possible to export to a dbase file (.dbf) in SQL Server 2005?
> Thanks,
> --
> Dan D.

export to dbf in SS2005

Is it possible to export to a dbase file (.dbf) in SQL Server 2005?
Thanks,
--
Dan D.Yes: you should create a Connection Manager OLE-DB for ODBC and select the
ODBC for your .dbf files
Gilberto Zampatti
"Dan D." wrote:

> Is it possible to export to a dbase file (.dbf) in SQL Server 2005?
> Thanks,
> --
> Dan D.

export to dbf in SS2005

Is it possible to export to a dbase file (.dbf) in SQL Server 2005?
Thanks,
--
Dan D.Yes: you should create a Connection Manager OLE-DB for ODBC and select the
ODBC for your .dbf files
Gilberto Zampatti
"Dan D." wrote:
> Is it possible to export to a dbase file (.dbf) in SQL Server 2005?
> Thanks,
> --
> Dan D.

Export table to dbf file

I need to export certain fields of a table from sql 2000 into a dbf
file, but can't find the proper query command to make it work. I also
want to set this up to run each night automatically.

Any help will be greatly appreciated.

RandyHi

You will probably need a scheduled DTS job, check out Books online for more
information about DTS and the following site is also very useful
http://www.sqldts.com/default.aspx

John

"Randy Henson" <rhenson@.cellxion.com> wrote in message
news:5dde95d2.0308220515.1232d9b5@.posting.google.c om...
> I need to export certain fields of a table from sql 2000 into a dbf
> file, but can't find the proper query command to make it work. I also
> want to set this up to run each night automatically.
> Any help will be greatly appreciated.
> Randy