Access query results to Excel

[Guest]

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]

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

 

[Guest]

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

 

[Nick Hodge]

This may help, the properties dialog is half way down

http://www.nickhodge.co.uk/gui/datamenu/importexternal.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk