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

Home -> Community -> Usenet -> c.d.o.server -> Re: Sometimes Select External Table from CSV File Return No Rows

Re: Sometimes Select External Table from CSV File Return No Rows

From: gazzag <gareth_at_jamms.org>
Date: 30 Aug 2006 03:21:04 -0700
Message-ID: <1156933264.564500.122470@i42g2000cwa.googlegroups.com>


EdStevens wrote:
> > > So I'm assuming your are opening it an saving it with Excel, so
> > > presumably Excel is doing some minor 'fixing' of the file. Have you
> > > tried opening it with Notepad and comparing that with same from a known
> > > 'good' file ... before you open it with Excel?
>
> I'd bee looking for *anything* that looks different in the way one file
> is formatted vs. the other. Nothing specific. Take a file you know
> isn't going to work unless you open and save it with Excel. Name it
> BAD.csv. Make another copy of the same file, named GOOD.csv. Now,
> open GOOD.csv with Excel, then save it. Now open both GOOD.CSV and
> BAD.csv *with notepad* and start looking for *anything* that is
> different.
>
> Just off-hand, I'd be willing to be a cookie that it is the way
> 'end-of-line' is treated.

All good advice but I'd use Vi fow Windows ibnstead of Notepad, personally. (http://www.winvi.de/en/)

Mircrosoft applications have a tendency to "protect" me from hidden control characters ;-)

HTH -g Received on Wed Aug 30 2006 - 05:21:04 CDT

Original text of this message

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