calling sql loader from vba

[whistler]

I have a access application front-end with an oracle back end (odbc)

On a daily basis we have to import a large text file into one of the Oracle tables. We do this by using the sql loader utility.
I have created a controlfile for this

I have two requests for help.
First: Please could somebody help me with some vba code to launch the sql loader exe (which is on the local drive) with this ctl file as its parameter from a button in a form in the access application.

Second: when the sql loader program will launch, a dos box is shown by it showing its load progress. It will close itself upon load completion. Now I need all vba code execution to pause until that dos box is closed. Any thoughts on that how to do it in vba ?

Thanks and best regards, Jos


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

 

[Douglas J. Steele]

Sorry, you haven't given enough details to give you specific instructions
for how to use the loader utility. What is "a controlfile"? Is it a batch
file? If so, you can use Shell to run it.

To wait until it's done, see http://www.mvps.org/access/api/api0004.htm at
"The Access Web"