using SQL*Loader from within VBA

[whistler]

I have the challenge to load large text files from a network drive (50,000 plus) into an Oracle back end db of my Access application. Obviously there is more than 1 way of doing this through Access functionalities (append queries, append through DAo recordsets, etc)

All these are quite too slow for me.

I would appreciate any thoughts, examples, recommendations towards integrating the usage of SQL*Loader in my VBA coding.

regards, Jos


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

 

[Arvin Meyer [MVP]]

Oracle may be optimized for using SQL*Loader since it is an Oracle product.
In general, dropping the index(es) and doing an append, then re-establishing
the index(es) is the quickest method of appending large quantities of
records.