ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Include Field Names - check box not available in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/228110-include-field-names-check-box-not-available-excel-2007-a.html)

Kimo

Include Field Names - check box not available in Excel 2007
 
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.


All times are GMT +1. The time now is 01:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com