Re: Converting from access 2000 to oracle 8

From: tasha <wrusaisuuod_at_jetable.org>
Date: 22 Sep 2003 05:55:12 -0700
Message-ID: <beb28290.0309220455.765fda84_at_posting.google.com>


"Tom Hester" <tom_at_metadata.com> wrote in message news:<bkfjf9$unt$1_at_sun-news.laserlink.net>...
> 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?

[Quoted] We'll get that a shot. Thanks for the reply! Received on Mon Sep 22 2003 - 14:55:12 CEST

Original text of this message