How to import access into SQL database

Many friends want to use the SQL2000 database programming method, but they are suffering from their own learning access, SQL is just a little bit of understanding, here I give you the following reference---the way to convert access to SQL2000 and considerations

First, I said in the access2000,sql2000 between the conversion, the other I have not tried, I hope we have a lot of experimentation, there is certainly a way;

Two, the method of conversion

1, open the "database source" in "Administrative Tools" under "Control Panel";

2, press "Add" to add a new data source, select "Driver do Microsoft Access" in the selection bar

(*.mdb) ", a box will appear when finished,

In the "database source" Enter the name you want to write, I named "ABC", that does not need to fill, and then, according to the following selection, find your database address and check (note, please back up your own Access database), and then determine.

The data source was built here, and the rest was converted.

3, open SQL2000 Enterprise Manager, enter the database, create a new empty database "ABC";

4, select the newly established database, press the right mouse button, select "All Tasks" under "Import Data", press "next" to continue;

5, select "Driver do Microsoft Access (*.mdb)" In the database source dropdown, and in the "User/System DSN", choose the "ABC" you just added and press "next";

6, "The purpose" does not need to modify, select the server (generally for their own local "local", you can also choose the server address or LAN address, determine whether your permissions can operate,), "Use Windows Authentication" refers to the operation of their own system administrator, "Using SQL Identity operation authentication "Can be used for website operations, recommended with the latter;

7, select "Use SQL Authentication operation Authentication", fill in your user name and password, I chose the system default number "SA", "* * *", the database Select just new "ABC", press "next";

8, this step of two single-choice, "Copy tables and views from the data source" and "Specify the data to be transferred with a query instruction", select the former, press "next" to continue;

9, here will appear your own Access database table, press "Select All" after the next step;

"DTS Import/Export Wizard", see "Run Now" is selected by pressing "Next",

11, press "done" to continue;

12, this step you will see your data is imported into the SQL2000 inside, when the "XXX table has been successfully imported into the database" word, and all the table has a green tick, indicating that all data successfully imported, if there is a problem in the middle or a red fork in front of the table, Indicates that the table has not been successfully imported, then go back to see if the operation is correct.

Third, data modification

1, because there is no "auto-numbering" in SQL2000, so your "AutoNumber" field will become a non-empty field, which must be manually modified these fields, and his "mark" select "Yes", the seed is "1", the increment is "1",

2, in addition, ACCESS2000 converted to SQL2000, the original property is "Yes/no" field will be converted to a non-empty "bit", when you have to modify the properties you want to;

3, in addition, we should pay attention to the time function of the grasp. There are many differences between access and SQL.

Transferred from: http://hi.baidu.com/%B5%E7%C4%D4%B4%EF%D7%D0/blog/item/8c5b4b131cf881c4c3fd7838.html

2009-12-28

This article is from the "Five Corners" blog, please be sure to keep this source http://hi289.blog.51cto.com/4513812/1764627

How to import access into SQL database