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

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 Tue Aug 22 2006 - 07:31:00 CDT