Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Include Field Names | Excel Discussion (Misc queries) | |||
Office 2007 trial to include Excel services | Excel Discussion (Misc queries) | |||
Include a Picture Field | New Users to Excel | |||
Need a macro to include file names in a folder to excel sheet | Excel Discussion (Misc queries) | |||
Can I check names in one list agains names in another in excel? | Excel Discussion (Misc queries) |