Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't Select External Table from CSV File

Re: Can't Select External Table from CSV File

From: Resant <resant_v_at_yahoo.com>
Date: 23 Jul 2006 20:24:45 -0700
Message-ID: <1153711485.543501.265550@h48g2000cwc.googlegroups.com>


I don't think so, because they use the same application. So they will create CSV file in the same mechanism. I think must be external factor - like Excel version (but I've already check that they have same version) or something else - that could be one of the cause. I can't think other, any other idea please?

Bib Endum wrote:
> "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 Sun Jul 23 2006 - 22:24:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US