This discussion is archived
3 Replies Latest reply: Aug 30, 2013 3:22 AM by mkirtley-Oracle RSS

msAccess to Oracle migration

Nuno Newbie
Currently Being Moderated

Hello

 

I'm trying to migrate a msAccess database to oracle. First of all, I do not have any MsOffice component in my workstation.

I couldn't even create a Access connection, I could only do that after installing a MS file called AccessDatabaseEngine.

Now, I'm trying to perform the migration process (with wizard), but whenever I reach the Source Database step (I am trying an ONLINE migration), the combobox with the possible sources is empty... and I DO have a MSAccess connection created (and Access does not show listed as a possible data source).

 

Do I need to install MSAccess to perform the migration?

 

My environment

Windows 7 64b

Oracle 11g

SqlDeveloper 3.2.20.09

 

Thanks for the help

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points