Import MS Access to SQL programmatically

Guest · Mar 23, 2005

I need to import several MS Access tables into SQL server 2000 tables. What
is the best/fastest method in terms of speed.

I tried the OLEDBReader for with SQLCommand to call a Stored Procedure with
parameters into the SQL tables. It seems like not the fastest import process
I've seen.

Can I use DTS, if yes, how? Thanks!

Mark Rae · Mar 23, 2005

Can I use DTS,
Yes.

if yes, how?

Define the two datasources and write the SQL

Robbe Morris [C# MVP] · Mar 24, 2005

You create a DTS package that points to your access database
and call the package. This sample does it with VBScript. It
could be adapted to do it with .NET using COM Interop.

http://www.eggheadcafe.com/articles/20030923.asp

Import MS Access to SQL programmatically

Guest

Mark Rae

Robbe Morris [C# MVP]