Save the file with .csv extension, use comma (,) as delimiter, put column in
double quote (").
Here is an example.
"","","","13314 Xya Street","","","","","HOUSTON","TX","77041","US","MY.COM"
"","","","1512 Dark Ave.
N.","","","","","SEATTLE","WA","98109","US","YOUR.COM"
"","","","1512W 23th SUITE
I","","","","","EMPORIA","KS","66801","US","THEIR.NET"
Jun
-----Original Message-----
Sent: Monday, September 24, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Hallo,
How can I create a excelfile with the UTL_FILE packet, I wantthe file to be
able to opened directly in excel, without goingthrough the import step when
I open the file.
Give me an example, please.
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Feng, Jun
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
