Re: Converting from access 2000 to oracle 8
Date: Fri, 19 Sep 2003 19:45:54 +0200
Message-ID: <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? Received on Fri Sep 19 2003 - 19:45:54 CEST