Re: Can't Select External Table from CSV File

From: Bib Endum <gd-newsgroups_at_spamex.com>
Date: Thu, 20 Jul 2006 23:39:34 -0400
Message-ID: <X%Xvg.13266$6t6.132152@wagner.videotron.net>

"Resant" <resant_v_at_yahoo.com> a écrit dans le message de news: 1153449915.844141.9060_at_i42g2000cwa.googlegroups.com...
> Hi all, I've a strange problem.
> I've have many 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
>

Just a stab in the dark: CR/LF conversion ? Received on Thu Jul 20 2006 - 22:39:34 CDT