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

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