Many friends want to use the programming method of SQL2000 database, but they are troubled by learning ACCESS and only have a little understanding of SQL. Here I will provide you with the following reference---Methods and precautions for converting ACCESS into SQL2000
1. First of all, I am talking about converting between ACCESS2000 and SQL2000. The editor of the website owner has tried it. I hope everyone can experiment more, and there will definitely be a way;
Test one by one program, if you have any questions, search on Baidu, the editor of the Error New Webmaster Website has updated the relevant articles before, and has perfectly solved this problem
2. The conversion method
1. Open "Database Source" in the "Administrative Tools" under "Control Panel";
2. Press "Add" to add a new data source, and select "Driverdomosoft Access" in the selection bar
(*.mdb)", a box will appear after completion,
Enter the name you want to write in "Database Source". I named it "ABC", which means you don't need to fill in. Then, press the selection below to find your database address and select it (note, please back up your ACCESS database first), and then confirm.
The data source is built here, and the rest is converted.
3. Open SQL2000 Enterprise Manager, enter the database, and create an empty database "ABC";
4. Select the newly created database, right-click, select "Import Data" under "All Tasks", and press "Next" to continue;
5. In the database source drop-down, select "Driverdomicrosoft Access(*.mdb)", in "User/System DSN", select the "ABC" you just added and press "Next";
6. "Purpose" does not require modification. Select the server (usually your own local "local", or you can also select the server address or LAN address to determine whether your permission can be operated,), "Using WINDOWS authentication" means operating with your own system administrator identity, "Using SQL identity authentication" can be used for website operations, and the latter is recommended;
7. After selecting "Use SQL Identity Operation Verification", fill in your username and password. I chose the system default numbers "sa" and "****", and select the newly created "ABC" of the database and press "Next";
8. Two single-item choices in this step, "Copy the table and view from the data source" and "Specify the data to be transferred with a query instruction", select the former and press "Next" to continue;
9. The table of your own ACCESS database will appear here. After pressing "Select All", the next step;
10, "DTS Import/Export Wizard", see "Run now" selected and press "Next",
11. Press "Finish" to continue;
12. In this step, you will see that your data is imported into SQL2000. When the words "XXX tables have been successfully imported into the database" appear, and all tables have a green check in front of it, it means that all data is successfully imported. If there is a problem in the middle or there is a red fork in front of the table, it means that the table has not been imported successfully. At this time, you have to go back to check whether your operation is correct.
Three, data modification
1. Since there is no automatic numbering in SQL2000, your fields set with automatic numbering will become non-empty fields. This requires manual modification of these fields and selecting its label as: seed is 1 and increment is 1.
2. In addition, after ACCESS2000 is converted to SQL2000, the field with the original attribute yes/no will be converted to a non-empty bit. At this time, you must modify it to the property you want.