View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
piano banger piano banger is offline
external usenet poster
 
Posts: 2
Default 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