Thread: Access query results to Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default 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

Reply With QuoteReply With Quote