Import ACCESS database data from ORACLE Database

1. First download and install Navicat for Oracle (here you can download) and install the software. next, you can.

9.0.15 registration code:

NAVP-J88X-4H3M-9YFP

NAV8-UVYK-U3RQ-WNVX

NAVE-H2CW-7RPE-YFVJ

2. Establish a connection

(Select sid, and enter the oracle IP address, user name, and password)

3. Open the connection

(Possible: ORA-12737: Instant Client Light: unsuppZ available? Http://www.bkjia.com/kf/ware/vc/ "target =" _ blank "class =" keylink "> memory + 1eK49srH19a3 + Memory + M/memory/C1Ni1xMrHMTAKILDmsb6jqTwvcD4KPHA + pgltzybzcm9" http://www.2cto.com/uploadfile/Collfiles/20140304/201403040901526.jpg "alt =" \ ">

Copy the four files oci. dll, orannzsbb10.dll, oraocci10.dll, and oraociei10.dll to the installation directory of Navicat for Oracle and replace the original one.

Open Tools --> Options of Navicat for Oracle, select OCI, select the oci. dll file in the corresponding directory, restart Nacicat for Oracle, and open the connection.

4. Import the access database data file (. mdb)

Connection Name --> oracle username --> Tables (right-click) --> Import Wizard

Select the file to be imported and the table to be imported.

Keep going Next

Start: Check whether the table, field, and data in the database are successfully or not.

Some problems may occur during the import process, which need to be studied.

This tool can also import excel files to oracle data and other types of data.