Re: Converting from access 2000 to oracle 8

Ralf Bensmann <r.bensmann_at_1ci.de> wrote in message news:<bkffeg$312$1_at_nets3.rz.RWTH-Aachen.DE>...
> tasha wrote:
>
> > Running the Oracle Migration Workbench Exporter for MS Access Release
> > 9.2.0.1.0
> > (against file omwb2000.mde) we are getting an error of the form
> > Error #-2147220502: Unofficial JET datatype encountered: column
> > xxx, table: yyy
> >
> > The datatype of the column is Number.
> >
> > Any ideas on how can we get around this? Are there any other ways to
> > convert an access db to oracle?
>
> Access and datatypes is a nightmare.
>
> I did a migration from Access 2000/MS SQL Server to Oracle 8i in the
> past. Because of similar problems I exported SQL statements from
> SQL Server and edited the statements by search and replace to run that
> script against sqlplus. Data was migrated by an csv export and import.
> Therefore I used an selfmade program. I think you should look at Oracle
> SQL Loader. You can script a data import with it.
>
> Did you check metalink?

Not yet. And thanks for the reply! Received on Mon Sep 22 2003 - 14:54:06 CEST