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.