LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Include Field Names KJKJKJKJ Excel Discussion (Misc queries) 0 July 29th 08 08:00 PM
Office 2007 trial to include Excel services bobostra Excel Discussion (Misc queries) 5 October 31st 07 02:43 PM
Include a Picture Field JethroUK© New Users to Excel 3 October 13th 07 06:32 AM
Need a macro to include file names in a folder to excel sheet anil Excel Discussion (Misc queries) 0 March 12th 07 09:10 AM
Can I check names in one list agains names in another in excel? John@Hospice of Hope Excel Discussion (Misc queries) 1 August 22nd 06 09:24 AM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"