Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Setting up external query without having Header Rows displayed in Excel 2007

Posted on 2010-08-20
4
Medium Priority
?
935 Views
Last Modified: 2013-11-05
In Excel 2003, when using Microsoft Query to setup queries to external data sources (such as another file, you had the option of "not including header rows".   In Excel 2007 I can't seem to find out how you do that?  It doesn't appear to be available under the "Properties" option on the Import Data.  I see that you have optoins on how you want to view the data such as Table, PivotTable, PviotChart and PivotTable and "Only Create Connection".  I might expect that "Only Create Connection" might give me this option, but when setting you a new connection to an Excel file, and after leaving Microsoft Query, it is "greyed" out so I can't select it.  

Any ideas?
0
Comment
Question by:StevenPMoffat
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
steverice earned 375 total points
ID: 33488766
Click anywhere in the query results area. Click on 'Table Tools'  in the menu bar at the top of the page, deselect 'Header Row'

Steve
0
 

Author Comment

by:StevenPMoffat
ID: 33489363
I tried this.  But the next time I executed the query, it put the header row back in.   Remember I have a query into an external data range that is associated with a table.  In Excel 2003, I could setup the query, adjust the properties to not include header row,  and associate it with an external data range, but no table was needed.  

Is there a way to setup a query in Excel 2007 (using Microsoft Query) so that I can turn off the header row?  There appears to be an option when setting up the query to chose "To just setup a connection" but that is greyed out for me.  
0
 

Author Closing Comment

by:StevenPMoffat
ID: 33495395
This solved the part about hiding header rows, but didn't address the question about how to use "the connection only" option.  I will pose it as another question as I have run into a number of other difficultes with setting up queries using Microsoft Query in Excel 2007 that I didn't experience in Excel 2003.
0
 
LVL 6

Expert Comment

by:steverice
ID: 33500610
Your second point was only a speculation as to what you might do to remove the header rows. I gave you an answer for this - your only question. But thanks for the points anyway....

I'll make sure I look out for your questions again....(to save me the time answering them)
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question