load csv data into linked table

[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 (the linked table - Invoice_tab ). 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 linked table) 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, any programming like sql loader or external tables in oracle is fine, but the end user uses only ms-access. plzzz help me, iam stuck here. or give some idea to proceed.

[Robeen]

Is the data travelling across a network?
I had users who had similar issues when pulling data into Access across our Wide Area network.

[acces2oracle]

As of now both access and oracle are on the same system (for the test purpose). In the future when it is succesful will be moved to production which will access the oracle through the network.