SQL Developer

Greetings,

I am currently trying to use Oracle SQL Developer to migrate and Access database into Orcale.

I have tried this four different ways and run into issues every time.

Oracle SQL Developer 2.1.1.64
Microsoft Access 2010 (64-bit)
2003 Access Database (32-bit)

First I created a connection to the MDB file and was able to connect and view the tables in the database. Initially I was getting some sort of permissions error but I was able to get that resolved by granting the admin user group read access to the system tables.

However when I try to right click on the access database and choose "Capture Microsoft Access" I see a tab in the editor open up with a blinking cursor but that's it. There's no indication anything is happening.

If I close the connection and then go to "Tools -> Migration -> Microsoft Access Exporter" and try to run the correct Access Exporter I get an error in access saying "This database was created with the 32-bit version of Microsoft Access. Please open it with the 32-bit Version of Microsoft Access.".

I have also tried saving the database as an .ACCDB file, however I am unable to even get SQL Developer to connect to that file as I get the error "Status : Failure - Test failed: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.

I realize that the default solution would be to load Office 2007 32-bit or something like that, but let's assume that I can't get a hold of it.

I was hoping there might be a solution that involved converting the Access database from 32 to 64 bit, or to get the SQL Developer to connect to the ACCDB file.


Any help would be great!


Thanks,