Import access database data to MSSQL database

Enterprise Manager Create a database in SQL Select All Tasks Import Data Select Microsoft Access from Data Source When importing the Access database to the MSSQL database, there are several issues that should be paid attention to When using MSSQL Server, there are many differences with Access, even if you use SQL Server to import the Access database, there are many places to pay attention to. 1. After importing the auto-numbering field often used in Access, it is not an auto-incrementing int, and it needs to be manually set to change the "no" of the imported auto-numbering field to "yes", and the "seed" and "increment" are both "1" in order to become an auto-number; 2. In MSSQL Server, there are many reserved words, which are not available in Access, and when you import data into MSSQL, the problem will come out. MSSQL will automatically add "[field name]" to these fields (including the table names in the database) when importing, so you must modify your script to add parentheses to the corresponding field names (or table names), or change the field names to non-MSSQL reserved words.

For specific ones, please refer to the relevant information) 3. In the use of access, we like to use "select * from aaaa while time="."

If you are using SQL 2000, you can use the DTS package or the data import and export tool.

I think you can try it like this, 1. Import access into SQL Server 2000 first, 2. Then export this library in SQL Server 2000, 3. Find the library exported in 2 through the data import tool in MySQL, and then import it into MySQL, so that there should be no problem with data encoding! My experience! You can try it!

Just press the import and export in that sql.,Step by step.,It's not very annoying.,It's probably just a few minutes.。

Methods for importing data from one access database into another access database:

1. In the Access 2010 External Data tab, in the Export group, click the Other button, and then click the Access Database button in the Other drop-down list. A window opens, and in the File Name text box, specify the name of the target database. If you do not overwrite an existing object with the same name in the target database, change the name of the new object in the Export-Access Database dialog box.

2. If the selected object is a table, specify whether you want to export the definition and data of the table, or only the definition. Click the OK button to complete the operation.

3. If there is an object with the same name in the target database, it will ask whether to overwrite the object, and click Yes to overwrite it. If you click No , you are returned to the Export-Access Database dialog box. You can also specify a name that is not used in the target database and click the OK button.