Oracle Database and Access mutual import instance

To import the actual application data of Access to Oracle, first open the Access database and select the table you want to import, change the table name and column name to uppercase letters (after the table name and column name are imported into the Oracle database, the table name and column name will be consistent with this), and then select the Save type as & ldquo; ODBC database () & rdquo ;. Next, if you have not created a DSN, you can create a new one. Follow the prompts to create an oracle DSN. The database name and user name to be connected will appear.

To import the actual application data of Access to Oracle, first open the Access database and select the table you want to import, change the table name and column name to uppercase letters (the table name and column name will be consistent with the name after being imported to the Oracle database), and select the Save type as "ODBC database ()".

Next, if you have not created a DSN, you can create a new one. As prompted, creating an oracle DSN will show the name, user name, and password of the database to be connected. Enter the correct name and test the connection, then click OK to import the data.

Create a user DSN: Control Panel-management tools-Data Source (ODBC), add a user DSN, select Oracle in

OraDb10g_homel, click "finish", and then enter a Name to add the TNS Server Name and user Name. After the connection test is successful, the data can be imported.

Oracle import Access

Use Access to import external data, enter the Oracle connection parameters to connect to the Oracle database, and select the relevant table to import.

Test results:

Access Data is imported into the Oracle database (no need to worry about it, tables are automatically created .)

If the Access field is "Chinese", it must be changed to "English.

Open the Access database, select the table to be imported, set the storage type to "ODBC database ()", and enter the name of the table you want to create (custom ). Other operations are the same as above.

The above content is the description of the actual operation steps for Access and Oracle Database mutual import. I hope it will help you in this regard.