Exporting MSSQL into SQL queries

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
theotheragentm
Forum Newbie
Posts: 9
Joined: Tue Jun 25, 2002 2:38 pm

Exporting MSSQL into SQL queries

Post 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.
sitething
Forum Newbie
Posts: 6
Joined: Sun Jul 27, 2003 7:08 pm

Post 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.
Post Reply