Comments on Software Engineer Thoughts: Extracting Data to Excel using only SQL*Plus

How to add a column header to this html output?

2008-07-01T15:20:00.000+02:00

How to add a column header to this html output?

Pawel,It is really working well. But is there any ...

2008-06-30T20:58:00.000+02:00

Pawel,

It is really working well. But is there any way we can remove this initial sql statement and add column headings to excel?

Your help is really appreciated.

Pawel,This trick is great as I have an web applica...

2007-09-11T23:29:00.000+02:00

Pawel,
This trick is great as I have an web application which handles many languages and I could not get output which is readable from queries. Thanks for the good tip.

- Susanta

ODBC is also an solution. But in my case I could n...

2007-07-10T07:59:00.000+02:00

ODBC is also an solution. But in my case I could not force it to work correctly with UTF8 data. I had data in many languages and lot of data get corrupted that way.

one thing you can try as well:define a dsn for ODB...

2007-07-10T01:21:00.000+02:00

one thing you can try as well:
define a dsn for ODBC in the client to the Oracle data provider and your database alias, setup oracle client on that pc and then run the query directly from inside Excel, using a SQL statement from inside the spreadsheet.
works quite well.