Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 fastest method to upload table from access to sql

Author  Topic 

lalbatros
Yak Posting Veteran

69 Posts

Posted - 2007-11-15 : 10:33:42
To upload data from an access mdb database to an sql server database, I compared the (naïve) use of a query and the use of a DTS package on the server. The second method was about 4 times faster.

I would be interrested to know about other methods or some "nice tricks" to make such an upload even faster.

Thanks
   

- Advertisement -