Access import/export of databases-illustration

ACCESS stores readable data and easy data migration. We use it as a backup file for small data to facilitate the import and export of various databases.

Address:Http://blog.csdn.net/chen_zw/article/details/18896259

Local ODBC Data Source Configuration:

To export or import data, you must first configure the local ODBC data source:

[1] Start --> control panel --> management tools --> data source (ODBC), as shown in:

[2] Select "add" and select the corresponding Oracle driver, as shown in:

[3] Enter Data Source Name casually --> select TNS Service Name --> click TestConnection --> enter the user Name and password --> click OK, as shown in:

[4] ODBC Data Source configured successfully!

ORACLE :( 1) import:

[1] Open the Access table --> switch to "external data" select an item card --> select "ODBC database" in the import --> select "import source data to the new table of the current database ", as shown in:

[2] select the data source Oracle_Access --> click OK --> enter the database user name and password --> OK, as shown in:

[3] select the database table to be imported (one or more tables are supported), as shown in:

[4] import successful!

(2) Export:

[1] Open the Access table --> select the Access table to be imported --> right-click --> export --> ODBC database, as shown in:

[2] enter the name of the table to be generated (Note: The table name must be in uppercase; otherwise, the table cannot be found in the Oracle database after export)

[3] select the data source Oracle_Access --> click OK --> enter the database user name and password --> OK to start Export, as shown in:

[4] exported successfully!

SQL SERVER:

Note: pit1

MYSQL:

Note: pit2

Note: This article only sorts out the ORACLE Import and Export methods. Here, we will dig a hole and fill it in later. Please add attention!