3

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?

Improve this question

2 Answers 2

Reset to default
1

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

Improve this answer
2
  • Tried that, seems to have the same problem. Copy-pasting to Word seems to work (but data is unreadable)
    – AlfaTeK
    Commented Jan 6, 2011 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
    Commented Jan 6, 2011 at 18:24
0

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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .