Using DTS to upload data from Access to SQL Server

Last Post 08 Apr 2002 03:15 PM by Roshec. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Roshec
New Member
New Member

--
08 Apr 2002 03:15 PM
Hi All,

I need to upload data (quickly) from Access DB to SQL Server, and I'm thinking about DTS, but I just don't know where to start, can anyone give me a heads up where to start?,
I currently have two ADO connections, one for access and one for SQL server, and I loop through every record in access and inserting them into SQL Server, and as you all know this is very very inefficient, so any help would really be appreciated...

thanks!


Acceptable Use Policy
---