Tutorial:
MSSQL-
Dr. Thomas E. Hicks
Import To MS-SQL-Server From 2003 Access Database
Computer Science Department
Trinity University
The purpose of this tutorial is to show how export a Microsoft 2003 Access Database into Microsoft SQL Server Express.
We are about to import a Microsoft Access Database into either Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express. Note that Microsoft SQL Server Management Studio Express is a free download for those who have Microsoft Visual Studio 2005.
Microsoft SQL Server Management Studio has an assortment of import tools included, but Microsoft SQL Server Management Studio Express does not. You can use this approach to transfer Access databases into either Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express
1] I have opened a Microsoft Access Database, called Northwind.mdb.
2] Using the mouse, hold down the Tools Menu -> Select Database Utilities -> Select Upsizing Wizard. (See Above)
3] Choose to either create a new database or replace data in an existing database. I am creating a new database. Using the mouse, select/push the Next Button. (See Above)
4] Select the SQL Server. Net5 is the name of my system. If you are using Microsoft Management Studio Express, you will have to add \SQLEXPRESS to your server thus making my NET5\SQLEXPRESS; If you have the complete Microsoft Management Studio, you simply use NET5. Using the mouse, select/push the Next Button. (See Above)
5] Select the tables you wish to transfer; I am selecting all of them. Using the mouse, select/push >>. (See Above)
6] The tables are now selected. Using the mouse, select/push >>. (See Above)
7] You can customize your selections if you wish, but I often just use the mouse and select/push the Next button. (See Above)
8] I generally choose to maintain my access and MS SQL Server databases as two separate entities. Using the mouse and select/push the Next button. (See Above)
9] Using the mouse and select/push the Next button. (See Above)
10] A GUI will keep you informed on the progress (See Above)
12] A progress report is generated. (See Above)
1] Open your connection
1] Note that the NorthwindSQL database was created; I expanded the Customers table on the right.. (See Above)