Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Importing TXT to Oracle with VB app

Re: Importing TXT to Oracle with VB app

From: <clucas_at_my-dejanews.com>
Date: 1998/12/07
Message-ID: <74gqfl$jmk$1@nnrp1.dejanews.com>#1/1

Thanks for your advice.

I read the entire SQL Loader documentation, and I couldn't figure a way to import, say, the 2nd and 4th fields from a variable-width, tab-delimited text file. It seems SQL Loader must import each and every column that's present on the file.

If you have any examples to define the data file, and could sent them this way? Thanks a lot!

--
## Cristian Lucas
## From Buenos Aires, Argentina

In article <74475v$mrk$1_at_brokaw.wa.com>,
  "Shawn Ramsey" <srams_at_nospamexcell.com> wrote:

> Shelling out to SQL Loader would be the fastestest and easiest way to load
> the data
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Dec 07 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US