Migrating .mdb files into Oracle on Linux

Migrating .mdb files into Oracle on Linux

I am using Java and Oracle. How can I read MS-Access .mdb files and put the data into Oracle in a Linux environment? I was able to do the same in Windows using odbc-jdbc. Is there any driver available for Java in Linux that can read .mdb files?

    Requires Free Membership to View

    Login

    When you register, my team of editors will also send you resources covering Linux administration and management; integration and interoperability between Linux, Windows and Unix; securing Linux and mixed-platform environments; and migrating to Linux.

    Cathleen A. Gagne, Senior Editorial Director

    By submitting your registration information to SearchEnterpriseLinux.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchEnterpriseLinux.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

It appears that Oracle has a product called Oracle Migration Workbench that appears to be the preferred way to migrate mdb files into Oracle.

Databases aren't my core area of expertise but my research comes up with some commercial solutions for odbc-jdbc connectivity on Linux. There is a company called DataDirect and another one called Easy Soft that make JDBC and ODBC drivers for Linux. I believe that OpenLinks software has a solution as that might work as well.

This was first published in September 2005