Exporting to Access

Hello, I occasionally have to take all the tables from a particular
database and dump the data into Access tables. When I use the wizard to do
this, I find that the tables in access must be empty prior to me stepping
through the wizard to export the data or otheriwse is kick the transaction
out as duplicate. I have been going into access and running a query for
each of the tables to delete all of the data.
Is there a way that I can do this all within SQL? Can I write the commands
to initialize those tables in access in some sort of SQL Proc?
Your suggestions would be greatly appreciated!!!!!!!!!How do you export data from sql server to Access ? Try
DTS export wizard tool available from sql server
enterprise Manager. It will let you delete all rows from
Access tables and then load data from sql to access. You
can also save the export options in a DTS package which
you can simply execute next time when you need to export
data. You can also schedule it to run on regular interval.
You can find more details about DTS packages in sql server
BOL, or post specific questions here.
hth.
>--Original Message--
>Hello, I occasionally have to take all the tables from a
particular
>database and dump the data into Access tables. When I
use the wizard to do
>this, I find that the tables in access must be empty
prior to me stepping
>through the wizard to export the data or otheriwse is
kick the transaction
>out as duplicate. I have been going into access and
running a query for
>each of the tables to delete all of the data.
>Is there a way that I can do this all within SQL? Can I
write the commands
>to initialize those tables in access in some sort of SQL
Proc?
>Your suggestions would be greatly appreciated!!!!!!!!!
>.
>|||Thanks