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?

Ron West wrote:

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.

--

On Jan 2, 11:14*am, Ron West
wrote:
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/MicrosoftAcces...Clipboard.html

Good luck.

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