Suggestion: Pull dataset from DB A, and insert it into DB B

[neualex]

Hi guys,

I am looking for suggestions here.
I need to run a query against a MS Access DB, and dump all that data into a SQL DB.

So, my approach, query the MS Access DB, then loop the RS, and insert record by record to the SQL DB.

I somehow think there must be a better way to do this.
Any ideas/suggestions?

Thanks,
...neualex

 

[PHV]

Use DTS ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886