Microsoft Access and Oracle

10 pts.
Tags:
Access
Microsoft Excel
Oracle
Oracle import/export
Can tables created in Access or Excel be imported into Oracle?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Use the Oracle Migration Workbench. You must also have the Plugin for MS ACCESS to be able to import the Access tables into Oracle

The Oracle Migration Workbench (OMWB) is a free tool that simplifies the process of migrating third party databases like Sybase, Informix, and DB2 databases to the Oracle platform. The Oracle Migration Workbench migrates the entire database schema, including triggers and stored procedures, in an integrated, environment. It can also perform the data move either online using JDBC or offline using scripts.

The OMWB is currently in transition from a standalone tool (OMWB 10.1.0.4) to an extension of SQL Developer (SQL Dev 1.5).

Informix & DB2(UDB and iseries) are still supported by OMWB 10.1.0.4.
Microsoft SQL Server, Sybase, MySQL and Microsoft Access are now supported by SQL Developer 1.5

More details and the free download can be found here
<a href=”http://www.oracle.com/technology/tech/migration/index.html”>http://www.oracle.com/technology/tech/migration/index.html</a>

1) select ms access table(s) for instance ADDRESSES
2) click at file menu—> export
3) select “save as type” as ODBC database
4) table name appears (OK)
5) create DNS, if you’ve already created then use it
6) provide username password for oracle
7) I think you’ve reached at your destination

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following