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.