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
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
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
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
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 Edit>Paste 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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks