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?
AlfaTeK
Posted 2011-01-06T17:15:09.917
Reputation: 428
1
You can use a 3rd party & better clipboard manager since MS Office's clipboard manager has limitations. I recommend Ditto.
Mehper C. Palavuzlar
Posted 2011-01-06T17:15:09.917
Reputation: 51 093
0
Excel has some quirks with copy & paste to maintain backwards compatibility with very older versions.
Tangurena
Posted 2011-01-06T17:15:09.917
Reputation: 324
Tried that, seems to have the same problem. Copy-pasting to Word seems to work (but data is unreadable) – AlfaTeK – 2011-01-06T17:34:29.347
Damn, I thought it's a clipboard problem... Anyway, giving an eye to this MS page can help, I hope.
– Mehper C. Palavuzlar – 2011-01-06T18:24:46.227