![]() |
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