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
>