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.
Showing posts with label updater. Show all posts
Showing posts with label updater. Show all posts
Friday, February 24, 2012
Subscribe to:
Posts (Atom)