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 -> Can't Select External Table from CSV File

Can't Select External Table from CSV File

From: Resant <resant_v_at_yahoo.com>
Date: 20 Jul 2006 19:45:16 -0700
Message-ID: <1153449915.844141.9060@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

Resant Received on Thu Jul 20 2006 - 21:45:16 CDT

Original text of this message

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