Re: HELP: SQL*Plus, SQL*Loader - invoke from VB ??

>I posted this about a week ago and got no response. Please help me with this
>one.
 

>I have a VB application that uses needs to transfer
>data between the Laptop (running Personal Oracle7)
>to the Workgroup Server (running Oracle Workgroup Server)
 

>I would like to automate as much as possible the extraction
>and update of data between the laptop and workgroup server.
>I would prefer to have a VB module (or menu option) that
>can invoke the data transfer process.
 

>I also need to do the same for laptop backups of data
>collected (in case of accident, etc).
 

>1) Can this be done ?? (IE invoke SQL*loader or SQL*Plus
> from VB 3.0 )
 

>2) I also considered using SQL*Plus to copy updated
> records to identical tables owned by an "exchange"
> user and using Export / Import to transfer them.
 

>3) Any other suggestions on how we can do this ???

cann't you use some sort of ODBC, where you can have more control on update and inserts? Received on Sat Apr 13 1996 - 00:00:00 CEST