MS QUERY COL HEADINGS

[don]

I have a query from Excel into a SQL2000 Database. I have some calculated
fields like datepart and also some combined fields.

The resultant query is retrieved without headings on calculated Columns.
Also using a field with AS statement does not work and after saving the
query and accessing again, the AS portion is gone.

Example: I enter: ihead.invoice_no AS 'Invoice',
save query, query returns column with heading of invoice_no.

Look at SQL again and it shows ihead.invoice_no ,

Just putting a space where the AS 'Invoice' was.

Probably a flag or setting, can't find in help, so asking group.

Thanks.

Don

 

[onedaywhen]

Sound like this could be the problem:

XL: Using a Field Alias in Query Does Not Work with Some Third-Party Databases
http://support.microsoft.com/default.aspx?scid=kb;en-us;298955

 

[Don]

(e-mail address removed) (onedaywhen) wrote in

http://support.microsoft.com/default.aspx?scid=kb;en-us;298955

I don't get any errors like this refers to, just loose the column header
when looking at the query and also when returning to excel.

Thanks for the response.