Load csv data to Oracle through Access

[acces2oracle]

Hi

My front end is Access and backend is oracle (moving to oracle). As of now iam using
Docmd.TransferText acImportDelim, , "Invoice_tab", filename, True to load csv data in Access database. I created Invoice_tab table in oracle and linked it in Access.


Now if I use the same Docmd it inserts the csv data into Oracle. It was working fine when i tried wit test data.
But now i tried inserting around 1 lac records. it is taking around 8 mins (to load into Oracle) where as the previous process took only 1 min (directly loading into ms-access database). Can anyone plz tell me is there any other way where i can laod csv data into oracle through access (front end should be access without writing a ctl file).

[Stingaway]

Create the ODBC link in Access to Oracle, import the data (or link to it) from Access, create an append / update query (as needed) to the linked Oracle table.