Page 1 of 1

Exporting MSSQL into SQL queries

Posted: Thu Jul 31, 2003 7:20 pm
by theotheragentm
I have someone who wants his MS SQL database converted to Access. Don't ask why. I don't know. The only way I can think of doing this is to take the existing database and exporting it to SQL queries that I can repopulate an Access database. Does anyone else have any ideas? Please let me know. This is somewhat urgent, because this person wants an answer tomorrow morning. Any help is greatly appreciated.

Posted: Thu Jul 31, 2003 8:14 pm
by sitething
You should be able in Enterprise Manager to use the Wizard (right-click on DB -> All tasks -> Export data) and choose your source as your SQL server, destination as MS Access. I don't think it will create an access db, but you can just create it beforehand and point the export at that file.