Friday, February 24, 2012

Import Access DB into SQL with OSQL?

Hello all.

I was wondering if there is a way to import an Access database into an MS SQL (MSDE) database using OSQL? I need to write an updater to send out to some customers, that will accomplish this. The Access database and its corresponding SQL database have the same table structure, i just need to update the data. I would like to use OSQL so I can make this process automated, behind the scenes of my GUI updater, for the customer.

I would love to be able to do something like this:

osql -E -Q"IMPORT DATABASE blabla FROM DISK = 'C:\blabla.mdb' WITH REPLACE"

Any ideas? Thanks so much all for looking.

JnuwNo one has a way for me to import an access database through a script or using osql? Help please, thank you all for looking.

No comments:

Post a Comment