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?

 

[Chris Premo]

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?

I've had this problem, it turned out to be an issue where the data in
the Ecxel file was 255 character and the Access field was 50 characters.

--

 

[Ed Hansberry, MS-MVP/Mobile Devices]

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?

Yes. Uninstall patch KB958437 that was part of the December
patches. If that fixes it, then just keep it uninstalled until MS
fixes the issue.
--
__________________________________________________________________________________
Ed Hansberry (Please do *NOT* email me. Post here for the benefit of all)
What is on my Pocket PC? http://www.ehansberry.com/
Microsoft MVP - Mobile Devices www.pocketpc.com
What is an MVP? -

 

[fmsinc]

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

"Thedataon theClipboardisdamaged, so Microsoft Access can't paste it.
There may be an error in theClipboard, 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?

Here's an article I wrote a few weeks ago that offers three
workarounds for this problem. Hope it helps:
http://www.fmsinc.com/MicrosoftAccess/Errors/ExcelPaste/Clipboard.html

Good luck.

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