RE: How to migrate Microsoft Access 2002 to Oracle 9.2 ?

From: Mitchell Baldwin <Mitchell.Baldwin_at_cogent-dsn.com>
Date: Tue, 21 Sep 2004 11:42:18 +0100
Message-ID: <A5E49A0595FB4A489ED566217349B1472DBC8C@zaphod1.cogent-dsn.local>

Use DTS in SQLServer it's very good and can cleanse/massage the data on = the fly.

-----Original Message-----

From: Daiminger, Helmut [mailto:HELMUT.DAIMINGER_at_wwk.de] Sent: 21 September 2004 11:08
To: LazyDBA.com Discussion; oracle-l_at_freelists.org Subject: How to migrate Microsoft Access 2002 to Oracle 9.2 ?

Hi!

Does anybody out there know of a way to migrate Microsoft Access 2002 to Oracle? The migration workbench only support Access 97 and 2000.

Or is the only option to create the tables and insert the data into Oracle via ODBC?

This is 9.2.0.4 on HP-UX 11.11.

Thanks,
Helmut
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 21 2004 - 05:36:54 CDT