"Go" Access database successfully imported into Oracle library method

First open the Control Panel-Administrative Tools-Data source (ODBC), add a data source driver for Oracle's user DNS, and fill in data source, Server Name, user, test for connectivity.

Then, open the Access database, select the table that you want to export, click Export on the File menu, select ODBC Databases () in the Save as type drop-down box, and then choose the DNS that you just established in machine data source in the pop-up dialog, select Data source. You can successfully import the database password into the Oracle library after you confirm it.

Note: The name of the Access table table that you want to export must be capitalized! Otherwise, when you import to Oracle, you can see the table, but when you query the table, the error "ORA-00942: Table or view does not exist" appears!

"Go" Access database successfully imported into Oracle library method