Oracle and Access

From: vidas <vidasm_at_yahoo.com>
Date: 26 Jun 2001 09:05:37 -0700
Message-ID: <cdbd2dd.0106260805.3cd6122c@posting.google.com>

Hi,

I have two databases - Oracle and MS Access. To perform a task I need to move around 100'000 lines from Access to Oracle over the network or vice versa.

Linking tables in Access seems to be not the best solution - those tables are already linked (are being updated) from other Access databases (one access mdb acts like a major database, other mdbs - as clients).
Via ODBS this process tends to be very slow.

Some suggestions?

thanks,
vidas Received on Tue Jun 26 2001 - 11:05:37 CDT