Re: Importing Tables from MC Access to Oracle 8

From: Mike Haegele <ubshag_at_rabbit.mchp.siemens.de>
Date: Tue, 13 Jul 1999 10:01:42 +0200
Message-ID: <378AF266.5D8D51C2@rabbit.mchp.siemens.de>

Jean Sok wrote:

> Hello all,
> What would be the most effective way to import tablesd from MC Access to
> Oracle 8.0.5?
> Is there a way to do it using designer 2000? Will I have an option to
> import just the data? or just the schema? What ODBC version is
> compatiable with MC Access 97 and Oracle 8.0.5?
> Thank you so much in advace.
>
> Jean

Hi,

the easiest way is an import from the Access File-Menue - Import to SQL-Database.
Maybe you have some problems with the import of Memo-Fields into Oracle, but this
was the only problem for me. The ODBC version 8.0.5 works well.

Hope it helps

Mike Received on Tue Jul 13 1999 - 03:01:42 CDT