up vote 3 down vote favorite
share [g+] share [fb]

I'm trying to copy-paste a query result from Access 2007 to Excel 2007 but some text columns that appear OK in Access are "cut-off" when pasting to Excel.

How to paste this correctly, avoiding the limit?

link|improve this question
62% accept rate
feedback

2 Answers

up vote 1 down vote

You can use a 3rd party & better clipboard manager since MS Office's clipboard manager has limitations. I recommend Ditto.

link|improve this answer
Tried that, seems to have the same problem. Copy-pasting to Word seems to work (but data is unreadable) – AlfaTeK Jan 6 '11 at 17:34
Damn, I thought it's a clipboard problem... Anyway, giving an eye to this MS page can help, I hope. – Mehper C. Palavuzlar Jan 6 '11 at 18:24
feedback
up vote 0 down vote

Excel has some quirks with copy & paste to maintain backwards compatibility with very older versions.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.