How an Access database imports an Oracle database

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

Then, open the Access database, select the table that you want to export, click "Export" on the "File" menu, in the Save Type Drop-down box, select the bottom of the "ODBC Databases ()", and then in the pop-up dialog box "Select Data Source" in the "Machine data source" in the DNS just established, You will be able to import the database password successfully into the Oracle library after you have identified it and then added it.

What to 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 that the table is visible, but the "ORA-00942: Table or view does not exist" error occurs when you query the table!