Re: Transfering Access 2000 mdb into Oracle 7/8
From: Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
Date: Tue, 5 Feb 2002 03:08:28 +0100
Message-ID: <a3nf3q$e908$2_at_as201.hinet.hr>
Date: Tue, 5 Feb 2002 03:08:28 +0100
Message-ID: <a3nf3q$e908$2_at_as201.hinet.hr>
Yes, it could be solution but the last one. There is a lot of columns in tables so it could be very hard to create all sqlldr control files.
-- Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR> "damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message news:3C5EEF79.A6B4CFFC_at_ci.seattle.wa.us...Received on Tue Feb 05 2002 - 03:08:28 CET
> How much data? On what operating system?
>
> I would just dump the data as vertical bar delimited ASCII and then
use SQL
> Loader.
>
> > 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.