Excel & Access 2007 SP1 - Data in the Clipboard "damaged"

[Ron West]

When I try to copy and paste data from Excel to Access (2007 SP1), I get the
following message:-

"The data on the Clipboard is damaged, so Microsoft Access can't paste it.
There may be an error in the Clipboard, or there may not be enough free
memory. Try the operation again."

There's no lack of memory that I know of - anyone have any ideas what is
causing this?

 

[joe_white]

Having exactly the same problem, would really appreciate any advice on a fix.

thanking you in advance

 

[joe_white]

here's the fix

http://www.fmsinc.com/MicrosoftAccess/Errors/ExcelPaste/Clipboard.html

security update for Excel 2007 (KB958437) causes the problem

thank goodness its sorted out !!

 

[Luke Chung-FMS]

Here's an article I wrote a few weeks ago that offers three
workarounds for this problem. Two which don't require removing the security
patch.

http://www.fmsinc.com/MicrosoftAccess/Errors/ExcelPaste/Clipboard.html

Hope it helps. Good luck.

Luke Chung
FMS, Inc.
http://www.fmsinc.com