Oracle database and Access cross-guide instances

To import the actual application data into the Oracle database tutorial, first open the Access database, select the table you want to import, and overwrite the table name with the individual column names (the table name and the column name will be the same as the list after you import the Oracle database). Then select the Save type as ODBC database ().

Next, if you do not create a DSN, you can create a new, according to the prompts, the establishment of Oracle DSN, will appear to be connected to the database name, username, password, the correct input after the test connection, correctly Click OK data to import.

Create a User DSN method: Control Panel-Administration Tools-Data Source (ODBC), add User DSN, driver selection: Oracle in

Oradb10g_homel, click "Finish" and then take a name, add TNS Server name, username, and test the connection after successful import.

Oracle Import Access

With the Import external Data feature of access, you can enter the Oracle connection parameters to connect to the Oracle database, and select the related tables to import.

Test results:

Access data to the Oracle database (without that much hassle, the table is created automatically.) ）

Forget, if the field of access is "Chinese" to Change to "English".

Open the Access database, select the tables you want to import, and then choose to save the type ODBC database (), and enter the name of the table (custom) you want to create. Other operations are the same as above.

The relevant content described above is a description of the actual operational steps of access and Oracle database interaction, hopefully giving you some help in this regard.