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

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 21 Sep 2004 09:16:56 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6501B25BF3@25exch1.vicorpower.vicr.com>

I prefer the prebuild & export via ODBC. Doing otherwise can create = problems from case sensitive objects.

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

From:	Mitchell Baldwin [mailto:Mitchell.Baldwin_at_cogent-dsn.com]
Sent:	Tue 9/21/2004 6:42 AM
To:	HELMUT.DAIMINGER_at_wwk.de; LazyDBA.com Discussion; =

oracle-l_at_freelists.org
Cc:=09
Subject: RE: How to migrate Microsoft Access 2002 to Oracle 9.2 ? Use DTS in SQLServer it's very good and can cleanse/massage the data on = =3D
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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 21 2004 - 08:12:41 CDT