I tried looking around the web how to accomplish the following task:
Convert SQL Server Database to Access MDB
I couldn't find any answer online, but on the way to work it hit me: use SQL Server Management Studio "Export". I just checked it and it works like a charm. In 2 minutes I was able to export the SQL Server database to Access MDB.
Just do:
1. Open SQL Server Management Studio & connect to the SQL Server database.
2. Right click the database and select - "Tasks" => "Export"
3. Select the source database & select Access MDB as destination.
Continue with the instructions.
Sunday, January 10, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment