Link to home
Create AccountLog in
Avatar of baleman2
baleman2

asked on

Microsoft Query output to Excel Spreadsheet

We use Microsoft Query as a query builder and export the data to an Excel spreadsheet.  When the spreadsheet opens, Excel's column names ( A thru ZZ) appear with the Data Table's Field names just below.

These field names can be quite long with the resultant data displayed in the column under the field name just being 2 characters wide.  An example would be a Data Field name being displayed as "Branch Number" and the data itself being "01" or "02" or "03".  I can't modify the Field Name itself because of other software that is dependent on those Field Names for data.

I was thinking of formatting the Field Name as:
B  N
R  U
A  M
N  B
C   E
H   R

using a SQL statement of some kind in the original query to display it as shown.

The purpose of this is so that I can display more Field Names with data on the printed page.  Right now, (even in Landscape mode) I can't get all the data squeezed in that I want the end user to see.  If I could turn the Field Names on edge or even at a tilt:
B  N
 R  U
  A  M
   N  B
    C   E
      H  R

this would allow me to add more columns that would print on a single piece of paper.

Please Advise.
ASKER CERTIFIED SOLUTION
Avatar of Missus Miss_Sellaneus
Missus Miss_Sellaneus
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
You could do like Missus Miss Sellaneus says and it would work like what I have in cell A1. If you want the results from B1, then do like I show:
User generated imageThen, squeeze the row down so it just holds two characters and type in the text: B N R U A M N B C E H R
You'll see the B1 cell display:
User generated image