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

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <Mitchell.Baldwin@xxxxxxxxxxxxxx>, <HELMUT.DAIMINGER@xxxxxx>, "LazyDBA.com Discussion" <oracledba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Sep 2004 09:16:56 -0400

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


-----Original Message-----
From:   Mitchell Baldwin [mailto:Mitchell.Baldwin@xxxxxxxxxxxxxx]
Sent:   Tue 9/21/2004 6:42 AM
To:     HELMUT.DAIMINGER@xxxxxx; LazyDBA.com Discussion; =
oracle-l@xxxxxxxxxxxxx
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@xxxxxx]
Sent: 21 September 2004 11:08
To: LazyDBA.com Discussion; oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l



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

Other related posts: