Re: SQL Loader

On 22-Jan-98 19:27:23 news.dial.pipex.com wrote:

>Is there a stand alone application similar to sql loader that could be
>called from VB4. I need to read from a txt file into an Oracle Dbase and
>would like a Vb way of doing so.
>Thanks in advance for any help.
>MW

Hello out there,

why don't you call the SQL*Loader from VB? The loader executable is called sqlldr73.exe (replace the 73 with your Oracle version) and resides in .../orawin95/bin or .../orant/bin. From VB it should be possible to call WinExec() or CreateProcess() to start the loader.

Hope that helps,
Lothar

--
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |