Import MS Access to SQL programmatically

[Guest]

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]

Can I use DTS,
Yes.

if yes, how?

Define the two datasources and write the SQL

 

[Robbe Morris [C# MVP]]

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