I'm wondering why transfering tables from Acces 97 works fine but in
Access 2000 got problems!
--
Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
"Steve M" <steve.mcdaniels_at_vuinteractive.com> wrote in message
news: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...
> > 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.
Received on Mon Feb 04 2002 - 20:05:39 CST
