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@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