Oracle exports database files in Access format

Source: Internet
Author: User
Tags odbc

A few days ago suddenly received a leadership task, to the oracle of several tables in the format of access to export, for never contact with access to me, heard this task a little confused, so began to find Niang, after a few hours of unremitting efforts, and finally successfully exported. Now take the steps to record, have been saved from forgetting later

Step One: Install Microsoft Access 2010 First (This step can be ignored for those that have already been installed)

Second step: After installation, open find external data = "ODBC data source

Step three: Create a new ODBC data source Follow the wizard directly next

Note: At first I was created in the Management tool ODBC data source, and then open the data source, as if there are 32-bit and 64-bit difference, has been error, and then directly in Access with ODBC data source creation success problem solved

Oracle exports database files in Access format

Related Article

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.