Cut & Paste

[Markjsr]

Normally, I have a database I've been updating from EXCEL by copying the
records from EXCEL, then pasting them into the ACCESS table.

Recently, however, it won't let me do this. It has begun giving me the
error message:

The data on the Clipboard is damaged, so Microsoft Office 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.

I've tried doing a reboot and doing it with only the EXCEL spreadsheet and
the ACCESS database open after the reboot. Still causes a problem. I have
no problem copy and pasting within EXCEL or within ACCESS, but if I try going
from EXCEL to ACCESS, I get this error message. Other Office applications do
not appear to be affected.

 

[Chris O'C via AccessMonster.com]

It's from a recent Excel security update. You can uninstall the update,
kb958437 (http://support.microsoft.com/kb/958437), or follow one of several
workarounds:

http://groups.google.com/group/micr...df598/bcae719d3dfc4a03?hl=en#bcae719d3dfc4a03


Chris
Microsoft MVP

 

[Luke Chung-FMS]

Here's an article I wrote a few weeks ago that offers three workarounds for
this problem. Including options that don't require removing the security
patch. Hope it helps:
http://www.fmsinc.com/MicrosoftAccess/Errors/ExcelPaste/Clipboard.html

Good luck.

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