Need to rename table columns in excel from a query

  • Thread starter Thread starter DFoster
  • Start date Start date
That's less than clear. Try explaining more, there's plenty of room in
cyberspace.

All I've got so far for advice is: Type in the new names.
 
In the older versions of Excel if you ran a query you could use the option
not to return the field names from a table. You could then use a row above
the data to act as a header row for sorting. In 2007 I cannot change the
field names in the header row and still refresh the query later. And if you
turn the header row off in the table then the sort function will not use
header information at all. If I'm still not clear let me know. I really
would like to find a solution to this.
 
In the older versions of Excel if you ran a query you could use the option
not to return the field names from a table. You could then use a row above
the data to act as a header row for sorting. In 2007 I cannot change the
field names in the header row and still refresh the query later. And if you
turn the header row off in the table then the sort function will not use
header information at all. If I'm still not clear let me know. I really
would like to find a solution to this.
Click to expand...

Oops, sorry. I don't have 2007 so I can't even guess.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to ignore a column of numbers in Grand Total for rows 1
Renaming columns in MS Query 2
rename worksheet tabs 2
VBA - retrieve data on last create named range from previous inserted named range 0
Help needed 0
renamed lines 0

Back
Top