Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    11

    Unanswered: 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.

    Jnuw

  2. #2
    Join Date
    Sep 2003
    Posts
    11
    No one has a way for me to import an access database through a script or using osql? Help please, thank you all for looking.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •