Import/Data from Oracle

[Guest]

Anymore know of way to import data from Oracle database?

Currently, I'm using DAO to import 2000 rows of data, but it's taking 40 min
to view all data.

Thaks

 

[Pat Hartman]

40 minutes is excessive. Perhaps there is something wrong with your code
loop.
Did you try linking to the Oracle table and running an append query to copy
the data to a local table?

 

[Lynn Trapp]

Just creating a link to the Oracle table should move faster than 40 minutes.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html