Import Microsoft Access tables into Oracle

10 pts.
Tags:
Microsoft 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

  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: 1  Reply

 
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
  • Brijesh
    Hi,

    Try this 

    Option Compare Database
    Function load_tables()
    
        Dim resposta
    
        varReturn = SysCmd(acSysCmdInitMeter, " ", 36)
        varReturn = SysCmd(acSysCmdSetStatus, " ")
    
        DoCmd.SetWarnings False
    
        varReturn = SysCmd(acSysCmdSetStatus, "Insert In Emb")
        DoCmd.RunSQL "INSERT INTO INFAR_Emb( Emb_ID, N_Registo, Descr, Compart, " & _
                                        "Data_Compart, Grupo_Hom_ID, Me_ID, " & _
                                        "Data_Alter, Data_Alt_Comp) " & _
                    "SELECT [Emb_ID], [N_Reg], [Descr], [Compart], " & _
                                        "[Data_Compart], [Grupo_Hom_ID], " & _
                                        "[Me_ID], [Data_Alter], [Data_Alt_Comp] " & _
                                        "FROM [Emb] where [Emb_ID]=257"
    and create again the odbc to assume the new values of the table.

    Hope this helps.

    9,680 pointsBadges:
    report

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