Access database to Oracle database sharing

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.