Heading values for SaveAs with Excel 1

[KevinYearian]

I am using SaveAs() to save a datastore as an excel spreadsheet with headers. My problem is that the column headings contain in the saved spreadshee show the dbname value of the column, not the text values from the datawindow headers.

Is there a way to make make the spreadsheet column headings be the text values from the Datawindow's header band?

Thanks,
KevinYearian

 

[leoashok]

1. First save that datawindow as html file format.
2. Internally create OLE object of excel application
3. Open the html file in the excel.
4. Saveas the html file as xls file format.
5. Close the excel application

 

[pgaec]

hmmm...there is an easier way for this problem

modify ur select statement from

SELECT sn,
gn
from employees

to

SELECT sn as Employee_Surname,
gn as Employee_GivenName
from employees

cheers
MM