import tables to Access automatically

[jianbo]

I want to import some tables(include data) from SQL server to Access automatically.
Currently I select records from SQL server and insert into Access one by one. This is a very slow way. When I use "import table" in SQL server to transfer tables to Access, it works very fast. I think there must be a better way to do it. Thanks in advance.

 

[jgoodman00]

You should be able to 'export' the data from SQL Server to Access using DTS.



James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures