Problem Seeing Headers...

If I use the "as" function, the output does not include the "as"
header like it would if I ran the same query in sql. This is
particularly irksome when the column returns a result, like "count",
and the header is blank.

I'm using excel 2003 to query a sql database.

Anyone encountered this? Got any tips?

-Brian

I find it works fine unless you go back through the query wizard to
edit the query.

In MSQuery's SQL window I added As XX in the following query

SELECT BillOfMaterial.BomID, BillOfMaterial."Product Number" As PN,
BillOfMaterial.Quantity, BillOfMaterial."Constituent Product" As CP
FROM OPDataSQL.dbo.BillOfMaterial BillOfMaterial

The headers were returned to Excel as PN and CP
On editing the query, MS query had lost the As clauses and I had to add
them again.

Bill Manville
MVP - Microsoft Excel, Oxford, England