Re: Problems migrating tables from Access to Oracle

If you have an ODBC connection to your Oracle database, then you can use Access's Save As/Export function to move the tables to Oracle...

Note: Before exporting change your Access Table Names to all upper case...Oracle does not like Mixed or lower case table names...it will accept them, but using SqlPlus and other tools will be much more complicated....

Hope it helps,,,

John G

"dev" <dev_at_nextmedia.fr> wrote:

>I am trying to move an Access 97 database to Oracle 8. I have tried to use
>the migrating assistant provided with Oracle, it asks me what database I
>want to migrate, but whatever Access database I choose, it crashes, telling
>me an unknown error occured with (-2147220908) as return code.
>Anybody got an idea about it ?
>Or an other solution for an easy migration of the structure and data of an
>Access database to Oracle ?
>
>
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Jul 21 1999 - 09:57:05 CDT