Create the ACCESS database student. MDB and create the table student as follows (if an Access database already exists, you do not need to create it ):
Student
Num |
Name |
Age |
Fromw |
School |
Major |
Score |
200706001 |
Zhang Fei |
19 |
Jilin Province |
Jilin University |
Linguistics |
388 |
200706002 |
Liu Bei |
20 |
Jilin Province |
Northeast Normal University |
Japanese |
328 |
200706003 |
Guan Yu |
19 |
Beijing |
Peking University |
Computer Software and Theory |
421 |
200706004 |
Mink Zen |
18 |
Sichuan |
Sichuan University |
Electronic Information Engineering |
376 |
200706005 |
Guan Hanqing |
18 |
Zhejiang |
Zhejiang University |
Computational Mathematics |
375 |
200706006 |
Qu Yi |
20 |
Zhejiang |
Zhejiang University |
Application chemistry |
402 |
200706007 |
Oman |
19 |
Beijing |
Peking University |
Library Management |
314 |
200706008 |
Abei |
19 |
Beijing |
Beijing University of Aeronautics and Astronautics |
Thermal Energy and Power Engineering |
348 |
200706009 |
Wu Zetian |
19 |
Shanghai |
Fudan University |
European and American Literature |
399 |
200706010 |
Liu Yunlong |
18 |
Liaoning |
Shenyang Industrial University |
Mechanical Manufacturing |
416 |
200706011 |
Fangge |
19 |
Liaoning |
Dalian University of Technology |
Applied Mathematics |
333 |
200706012 |
Wang da |
21 |
Tianjin |
Tianjin University |
Network applications |
342 |
200706013 |
Xi Shi |
18 |
Tianjin |
Nankai University |
Data Warehouse |
411 |
200706014 |
Li Shimin |
18 |
Jilin Province |
Changchun University of Technology |
Information Management and Information System |
364 |
200706015 |
Wang Mang |
19 |
Hubei Province |
Wuhan University |
Solar energy |
294 |
200706016 |
Zhu Yuanzhang |
18 |
Hubei Province |
Wuhan University |
Geothermal energy |
352 |
200706017 |
Zhuge Liang |
19 |
Beijing |
Tsinghua University |
Data Mining Technology |
434 |
200706018 |
Shida |
20 |
Beijing |
Beijing University of Science and Technology |
Energy Machine Engineering |
319 |
200706019 |
Hongfeng candle |
18 |
Beijing |
Beijing International Studies University |
Foreign Language Culture |
347 |
200706020 |
Liu Yan |
18 |
Heilongjiang |
Harbin Institute of Technology |
Electrical Engineering and automation |
405 |
Start the SQL Server 2000 Service Manager and open the Enterprise Manager.
Select the database icon, right-click, and select import database under the "all tasks" list ",
Click "Next ":
You can select multiple data sources:
Because we want to convert the Access database to the SQL Server 2000 database, select "Microsoft Access" for "Data Source ",
Select a server (local) as needed for "server". For authentication, click "Next ":
If you have set the user name and password for the Access database, you must enter the user name and password, and you can also configure it through the "advanced" connection attribute.
Select the "file name" of the Access database to be imported, click "Next", and select the database to be imported:
You can select an existing database from the drop-down list box or create a new database:
Click "OK" and click "Next ":
Click "Next ":
Click "Next ":
Click "Next ":
Click "finish ":
In this way, the ACCESS database is successfully converted to the SQL Server 2000 database. In the Enterprise Manager, you can view the converted database:
Note: You need to refresh the page to see the converted database, because we have created a new sky2098 database.
Now, the conversion is complete.