|
Re: MS Access to Oracle Database [message #420748 is a reply to message #420744] |
Wed, 02 September 2009 00:37 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
In my opinion, Forms is a wrong tool if you want to "import" data from one database into another. I'd rather use Oracle Migration Workbench (which is now part of Oracle SQL Developer).
There are other ways to do the same, such as loading CSV files with SQL*Loader or using Oracle's external tables feature.
However, if you insist, you might check Maaher's example in this thread which explains how to connect a MS database with Oracle one. Furthermore, search the board for ODBC, Access and SQL Server in order to find more information.
[Updated on: Wed, 02 September 2009 00:37] Report message to a moderator
|
|
|