Re: Converting Access 97 to Oracle 8

As long as you have an ODBC connection defined for your Oracle database, you can export Access data directly to Oracle ( it will create and populate the table)...

Some caveats:
Be sure your field names and the table name are Upper Case - Oracle does not like lower or mixed-case stuff...

Since you cannot specify the tablespace used ( as you can when upscaling from Visual Fox Pro ) - the table will be created in your default tablespace - if you wish to put it elsewhere, set that as your default before exporting ( and reset it after).

Other than that, it works pretty well....( don't delete your Access table until you are very sure you have it in Oracle !!! )

Good Luck,
John Greco
Oracle DBA/Application Developer
Email to john.greco_at_dot.state.mn.us

Simba Lion <simbalion_at_home.com> wrote:

>
> I've come across a few methods to export Access 97 data to MySQL, and
>mSQL, and I'm wondering if there is a similar way to export Access data
>into an Oracle 8 format. Any information on this would be greatly
>appreciated, as would email replies.

To reply please remove the 'nospam' part of the address Received on Fri Feb 19 1999 - 13:36:49 CST