Shulou(Shulou.com)05/31 Report--

This article mainly explains the "ACCESS into SQL2000 need to pay attention to what are the problems", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "ACCESS into SQL2000 need to pay attention to what are the problems"!

First of all, I'm talking about switching between ACCESS2000,SQL2000. I haven't tried anything else. I hope you can try it a lot. There must be a way.

Second, the method of conversion

1. Open Database Source in Administrative tools under Control Panel.

2. Press "add" to add a new data source, and select "Driver do microsoft Access" in the selection column.

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

Enter the name you want to write in the "database source". I'll call it "ABC", which means you don't need to fill it in. Then, press the selection below to find your database address and select it (note, please back up your ACCESS database first), and then make sure.

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. Select "Driver do microsoft Access (* .mdb)" in the database source drop-down, and in "user / system DSN", select the "ABC" you just added, and click "next"

6. "purpose" does not need to be modified. Select the server (generally, it is your own native "local", or you can also select the server address or local area network address to determine whether your permissions can be operated). "using WINDOWS authentication" refers to the operation with your own system administrator identity. "using SQL authentication operation" can be used for the operation of the website. The latter is recommended.

8, the two individual selections for this step, "copy tables and views from data sources" and "specify 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" is selected and press "next"

11, press "finish" to continue

12, this step you will see your data is imported into SQL2000, when the words "XXX tables have been successfully imported into the database" appears, and all tables have green ticks in front of them, it means that all data has been successfully imported. If there is a problem or there is a red cross in front of the table, it means that the table has not been successfully imported. At this time, you should go back and check whether your operation is correct.

Third, data modification

1. Since there is no "automatic numbering" in SQL2000, your fields set with "automatic numbering" will become non-empty fields, so you must manually modify these fields and mark them as "Yes", seed as "1" and increment as "1".

2. In addition, after ACCESS2000 is converted to SQL2000, the field with the original attribute of "Yes / No" will be converted to a non-empty "bit". At this time, you must change it to the attribute you want.

3, in addition, we should pay attention to the grasp of the time function. Access and SQL are many different.

Thank you for your reading, the above is the "ACCESS into SQL2000 need to pay attention to what are the" content, after the study of this article, I believe you need to pay attention to the conversion of ACCESS into SQL2000 what this problem has a deeper understanding, the specific use of the need to practice to verify. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.