help with csv file

kyuan1 · #1 (**permalink**) 10-28-03, 17:18

I am using UTL_FILE object in Oracle 9i to create an excell report.
The excell report contains multiple sheets with it. Any one knows how to
put the data extracted from tables into different sheets? I know how to
do with the single sheet report, but no idea with the multiple sheets report. Very much appreciate your help!

Kevin

anacedent · #2 (**permalink**) 10-28-03, 19:47

Quote:

Originally posted by kyuan1
I am using UTL_FILE object in Oracle 9i to create an excell report.
The excell report contains multiple sheets with it. Any one knows how to
put the data extracted from tables into different sheets? I know how to
do with the single sheet report, but no idea with the multiple sheets report. Very much appreciate your help!

Kevin

Just curious...
Why are you dumping Oracle data to CSV files
when Excel via OBDC can "ingest" the data directly?

chumpski · #3 (**permalink**) 10-29-03, 04:43

and how can you use it to "ingest" the data directly into an Excel spreadsheet?

anacedent · #4 (**permalink**) 10-29-03, 10:46

Quote:

Originally posted by chumpski
and how can you use it to "ingest" the data directly into an Excel spreadsheet?

Oops.
ODBC - Open Data Base Connectivity
Within Excel
Data->Get External Data->Create New Query
This "assumes" Oracle Client s/w is installed on the PC
and it can connect to the target DB.