Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transfering Access 2000 mdb into Oracle 7/8
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...
> What is the easiest way to transfer Microsoft Access 2000 database into
> 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 - 15:15:05 CST