Copying from Access & pasting to Excel

[Roach]

Hello all,

Whenever I copy results of an Access query into Excel, it always wraps my text. Then I have to format and unwrap. Is there a way to change the default to not wrap the text? I tried to ask the Excel forum and got no help there.

Sorry if this question is not meant for this forum, but I can't get answers anywhere else.

Great thanks in advance.

Peace,
Roach

 

[ghudson]

Edit / Paste Special As Text in Excel

 

[Roach]

Reply

Not sure (Microsot Office 2000 SR-1 Professional) and yes, its Windows XP (2000 professional). Thanks.

 

[Roach]

Ah ha!

Now I got it. Thank you very much. It worked.