Access database to Oracle database sharing

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

There are many articles on the Internet to introduce access to Oracle database methods, I have tried, not very successful, listed, Up-and do not have to blindly try, basically unsuccessful:

1, Access-->excel-->pl/sql-->oracle

2, Access-->txt-->sqlload-->oracle

Both of these fields make a bad mistake.

3, SQL Server and Winsql, this operation is quite complex, especially winsql

4, through the ODBC data source Direct access-->oracle

Basic ability, but the table structure of Access database, table data, etc. affect conversion success. For example, access requires a table name capitalization.

And then looking for a lot of Oracle graphical management software such as SQLyog Enterpris, Plsql Developer, Toad for Oracle 10, Navicat for Oracle, and so on, try it, and finally use Navicat for Oracle completes the conversion and is simple and fast.

We recommend that you use Navicat for Oracle to guide Access databases later.

In the following illustration, access is imported into the Oracle process:

1, first download installation navicat for Oracle, I use the version is 9.0, version does not matter, not less than 8.0 can.

2, open Navicat for Oracle, point menu-file-New connection, pop-up the following figure:

Username here Note: Oracle generally enables the SYS, SYSTEM, DBSNMP, Sysman four default users, although the SYS user has the highest permissions, but must fill in the SYSTEM user name connection.

Click on the connection test to connect successfully.

3, next open the following interface

4, right key point "table", point "Import Wizard", pop-up the following diagram window:

5. After a few steps, select to open the Access database, you can select the table to import, you can choose more:

6, select the relevant table name after "Next", the following figure appears. You can specify which table to import into Oracle, or you can enter a new table name.

7. Next, select the fields you want to pour

8, after the election, next, select the mode to import, the general election of the first can be

9, the next step, start the conversion, soon the following window appears.

10. Successful import.