K
Kimo
I recently got a new laptop with Office 2007. I have been running queries
against a DBII database for years now using Excel 2k, XP and 2k3.
Now, in Excel 2007, I am unable to see "Include field names" in the External
Database Properties dialog.
The help file tells me this:
To include field names as the first row, select the Include field names
check box. Note: This check box is only available for an external data range
that is converted from a Microsoft Office 2003 program, or to an external
data range that is created programmatically.
That makes no sense to me. Does this mean I need to write the query in Excel
2003 and then convert it to 2007? That seems like an enormous effort. I don't
understand what "programmatically" means either.
I am trying to write queries that the end users can refresh without needing
to overwrite the database column headers every time they do so.
Thanks in advance for any help.
against a DBII database for years now using Excel 2k, XP and 2k3.
Now, in Excel 2007, I am unable to see "Include field names" in the External
Database Properties dialog.
The help file tells me this:
To include field names as the first row, select the Include field names
check box. Note: This check box is only available for an external data range
that is converted from a Microsoft Office 2003 program, or to an external
data range that is created programmatically.
That makes no sense to me. Does this mean I need to write the query in Excel
2003 and then convert it to 2007? That seems like an enormous effort. I don't
understand what "programmatically" means either.
I am trying to write queries that the end users can refresh without needing
to overwrite the database column headers every time they do so.
Thanks in advance for any help.