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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment