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:
Roland,
Just use CSV as a extension, as long as your fields are comma separated it
should be okay. I put all my fields enclosed in double quotes to be safe.
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at
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
I'm not sure what you mean by going through the import step. If this
means you want to write something other than a comma seperated file, I
don't have an answer. If you can use a csv file what we do is write a
file with the extension .csv. Because it is part of an application
with many things
Roland,
IFf you separate each column with the tab character (chr(9)), excel will
open the file without requiring you to go through the import steps.
You should be aware that the file is still not a true Excel file, and that
when you save the file, you will then be asked if you want to save it