Bulk Import of Data into an Oracle Database

[ashwah]

I am in a position where I want to get a quantity of data into an Oracle database. My current attempt is using ADO and am finding it to be quite slow as I am looping thru the recordset and firing an INSERT command for each record.

The reason I am using this method is because I am running various bits of vba code at scheduled times and would like to inlcude this process in the same schedule.

Any idea of how I could speed this up, keeping it within vba but not necessarily using ado? The number of records I want to send over is about 25000 if that helps.

Thanks
Ash

[r035198x]

Where is the data coming from? A csv file?

[ashwah]

Thes source is an Oracle Database back end of a workforce managent software package. Basically I'm going from Oracle to Oracle here. But with a view to using different DBs as the source in the future.

[debasisdas]

For oracle to oracle you can use DBLINK to connect to the other server and run through a procedure. You can schedule the procedures to run at differnt times by using JOB.

to go for a different database ,you can export the data to flat file and load into the desired database.