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

Resant wrote:
> I have opened the files based on your instruction, but found any
> difference. Actually would should I looking for in two kind of files?
> Please give some clue.
>
> Thanks
>
> EdStevens wrote:
> > Resant wrote:
> > > Sori, I've to post this problem again in this forum, 'cause I didn't
> > > get satisfied answer.
> > > My problem is :10id\fifi.soekianto client that submit their data in
> > > CSV file to central
> > > database. Then I use external table to get the data. It's works fine at
> > > all client except one!
> > > I can't select the external table from that client's CSV. The table
> > > show no returned rows.
> > > But when I open the CSV files and save directly without change
> > > anything, the external tables can show the data.
> > > I've check Excel version already and it's the same as other client.
> > > What should I do? Any clue?
> > >
> > > Thank you
> > >
> > > Resant
> >
> > 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. Received on Fri Aug 25 2006 - 15:28:28 CDT