Home » Developer & Programmer » Forms » MS Access to Oracle Database
MS Access to Oracle Database [message #420744] Wed, 02 September 2009 00:14 Go to next message
Messages: 3
Registered: May 2007
Location: Pakistan
Junior Member

I want to import MS Access data to oracle tables using Form6i.
Can anyone help me?
Re: MS Access to Oracle Database [message #420748 is a reply to message #420744] Wed, 02 September 2009 00:37 Go to previous message
Messages: 21130
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

Previous Topic: Open Forms 10g in browser full screen mode(F11)
Next Topic: WEBUTIL - FORMS - 100501 Non Oracle exception
Goto Forum:

Current Time: Tue Jul 25 22:00:21 CDT 2017

Total time taken to generate the page: 0.10058 seconds