Import/Data from Oracle

S

slimla

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
 
P

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to change Crystal Reports settings from Oracle to SQL 0
Adding data to MS Access from csv file 0
Link table from Oracle database 0
Formatting Text from Excel 1
Linking to Oracle 5
Problem connecting Access to Oracle 0
coonnecting to Oracle Database 1
Import NCLOB field from Oracle to MS Access 2003 2

Top