Importing TXT to Oracle with VB app

From: <clucas_at_my-dejanews.com>
Date: 1998/12/02
Message-ID: <743ul2$q9$1@nnrp1.dejanews.com>#1/1

Help please!

What's the best way to import a large (35 MB) tab-delimited text file into Oracle? It must be done from within a VB App. I guess the worst way is using a loop through all records, and parsing and INSERTing them. Perhaps I could use some ODBC definition to treat the TXT as a table..? Or could I shell some Oracle tool with the appropiate command line parameters to do the task?

I'm using RDO and VB5. Any help greatly appreciated.

TIA

--


## Cristian Lucas

## From Buenos Aires, Argentina


-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

Received on Wed Dec 02 1998 - 00:00:00 CST