Re: Importing Access Data

From: Huebner, Matthias <info_at_verkehrsberatung.net>
Date: Fri, 4 Oct 2002 14:59:39 +0200
Message-ID: <3d9d9f79$0$260$626a54ce@news.free.fr>

Salut,

"K Allen" <allenkb_at_nbnet.nb.ca> schrieb im Newsbeitrag news:V_6n9.14119$0i4.1529684_at_ursa-nb00s0.nbnet.nb.ca...
> What is the easiest way to import my access tables into Oracle 8I????

i will connect the new oracle tables to my old access database and then execute an:

INSERT INTO <new_connected_ora_table> SELECT * FROM <old_mdb_table>

do not forget to rebuild indexes in ora after having filled the tables. drop all indexes before executing the insert and rebuild later will fasten your operations with large tables.

hth
Matthias Received on Fri Oct 04 2002 - 07:59:39 CDT