Re: Converting from access 2000 to oracle 8

From: Tom Hester <tom_at_metadata.com>
Date: Fri, 19 Sep 2003 12:01:32 -0700
Message-ID: <bkfjf9$unt$1_at_sun-news.laserlink.net>


[Quoted] Yep, it is a headache. The problem is that numbers are a different size on the two systems. Simplest fix is to change the number in as varchar...

"tasha" <wrusaisuuod_at_jetable.org> wrote in message news:beb28290.0309190932.71fa9ce0_at_posting.google.com...
> 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?
Received on Fri Sep 19 2003 - 21:01:32 CEST

Original text of this message