Access query results to Excel
 

I transfer a lot of Access query results into Excel spreadsheets. Anyone
know of a way to 1) not carry the header line and 2) not have the data 'word
wrap'.
--
puzzled

Access query results to Excel
 

I don't know of any way to avoid pasting the field headings.
To prevent wrapping, choose EditPaste Special
Select Text, and click OK

piano banger wrote:
I transfer a lot of Access query results into Excel spreadsheets. Anyone
know of a way to 1) not carry the header line and 2) not have the data 'word
wrap'.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Access query results to Excel
 

Thanks, Debra. That will save a lot of time on many of my reports.
--
puzzled


"Debra Dalgleish" wrote:

I don't know of any way to avoid pasting the field headings.
To prevent wrapping, choose EditPaste Special
Select Text, and click OK

piano banger wrote:
I transfer a lot of Access query results into Excel spreadsheets. Anyone
know of a way to 1) not carry the header line and 2) not have the data 'word
wrap'.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Access query results to Excel
 

"piano banger" wrote:

I transfer a lot of Access query results into Excel spreadsheets. Anyone
know of a way to 1) not carry the header line and 2) not have the data 'word
wrap'.
--
puzzled

It's hiding in the 'Query Properties' dialogue box, and it's the very devil
to find. Easiest way I know is to ask the query to return the data to the
spreadsheet, and then click on the properties box, and then turn off the
header line. This can be accessed from a left click on the cell containing
the query, also, if you've gotten that far. Notice that the parameter box is
there also. I've never found any documentation on this anywhere, MS and Que
included. I don't want to tell you how long it took me to find this, I might
get fired.

Access query results to Excel
 

This may help, the properties dialog is half way down

http://www.nickhodge.co.uk/gui/datam...rtexternal.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"bookmanjohn" wrote in message
...


"piano banger" wrote:

I transfer a lot of Access query results into Excel spreadsheets. Anyone
know of a way to 1) not carry the header line and 2) not have the data
'word
wrap'.
--
puzzled

It's hiding in the 'Query Properties' dialogue box, and it's the very
devil
to find. Easiest way I know is to ask the query to return the data to the
spreadsheet, and then click on the properties box, and then turn off the
header line. This can be accessed from a left click on the cell
containing
the query, also, if you've gotten that far. Notice that the parameter box
is
there also. I've never found any documentation on this anywhere, MS and
Que
included. I don't want to tell you how long it took me to find this, I
might
get fired.