Importing Data us Excel Data/From Other Sources/MS Query

Ceriga

New Member
Joined
Jul 30, 2014
Messages
1
I'm using MS Query to create reports that can be refreshed (Data/From Other Sources/MS Query). Once the data is pulled into Excel (2007), the column headings are those of the Safari report that I am querying. I can update the SQL code with <select field name> as <new name> but this is cumbersome to do for many data fields and queries.

I am looking at an Excel sheet that was created by someone else. The column headings are stable and do not change when the report is refreshed. It is not using the SQL code above. I can right click on the column heading, select "define name" and this is what I see :

Name: Guest_Type
Scope: Workbook
Refers to: =Sheet1!$A$2

Yet, the actual column heading is "Guest Type" (without the underscore), and the defined name does not appear in the formula box - it says A2 as it normally would.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,099,045
Messages
5,466,222
Members
406,473
Latest member
Dunno123

This Week's Hot Topics

Top