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

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?
Received on Thu Aug 24 2006 - 20:17:37 CDT