Convert SQL Data

I am looking for a way to convert SQL data to Access 2002 format. I want to
be able to view the data in access. Is there a way to connect to my SQL
server with access and be able to view and save the databases to the access
format. I want to be able to have a DBF copy of my access databases in the
event of a total failure.KMD,
There are a couple of ways to do this. 1) you can use Access to import your
SQL Server database into Access. This is probably the easiest way. 2)
Attach the SQL Server tables to your Access database. From there you can ru
n
queries that create new tables or just keep them attached and view them that
way.
Hope this helps.
Scott
"kmd" wrote:

> I am looking for a way to convert SQL data to Access 2002 format. I want
to
> be able to view the data in access. Is there a way to connect to my SQL
> server with access and be able to view and save the databases to the acces
s
> format. I want to be able to have a DBF copy of my access databases in th
e
> event of a total failure.
>
>