Re: Transfering Access 2000 mdb into Oracle 7/8
Date: Mon, 4 Feb 2002 13:15:05 -0800
Message-ID: <a3mtc7$3p6$1_at_spiney.sierra.com>
The errors you are getting may be related to MS-Access field-type
incompatibility.
Consider creating the tables in Oracle first. Then append.
For those tables which produce errors, check all field types and convert to
simpler (i.e., more "oracle-like") fields.
If I remember correctly, even Access has some "export" problems with
INTEGERs. Try using only LONGs, TEXTs, and DATEs.
"Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message
news:a3mmbq$d314$1_at_as201.hinet.hr...
> Oracle7 (7.3.4) or Oracle8i (8.1.7) database? I have tried Microsoft
> ODBC and original Oracle's ODBC drivers but without success! I only get
> some strange error messages! Sometimes, with some tables it works but
> not with all tables.
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
>
Received on Mon Feb 04 2002 - 22:15:05 CET