"The data on the Clipboard is damaged."

[Dick Watson]

For years I've pasted some data from an Excel .CSV to an Access form.

Starting the day I installed this weeks patch bundle, I get the following
message from Access on attempting the paste:

"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."

Pasting the data into Notepad, Select All, Copy, Paste into the Access form
works fine.

Is it possible one of this week's patches BROKE something??!?

Any thoughts?

 

[Dave Peterson]

I read this subject line in another forum, but I didn't try to verify anything:

Excel Patch KB958437 Prevents Copying data to Access 2007

Maybe that's the patch you should start with???

 

[Dick Watson]

I hate it when that happens. All this emphasis on "you have to install these
patches ASAP" presumes they don't BREAK other stuff.

Hopefully they will fix soon. I will have to uninstall that one. A real
operational problem encountered everyday trumps a speculative security
problem that is unlikely to effect me ever.

Thanks! I added validation and a rating to the Connect item. Let's hope MS
takes note and issues a new patch.

 

[Dave Peterson]

Please post back with your results after you uninstall and test the copy|paste.

 

[Dick]

For years I've pasted some data from an Excel .CSV to an Access form.

Starting the day I installed this weeks patch bundle, I get the following
message from Access on attempting the paste:

"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."

Pasting the data into Notepad, Select All, Copy, Paste into the Access form
works fine.

Is it possible one of this week's patches BROKE something??!?

Any thoughts?

Accidently found another work around. Copy the data then exit Excel and
when Vista asks if you want to save it say yes. Then you can paste
append into your Access table. At least I have been able too.

 

[Dick Watson]

Joy.

 

[Dave Peterson]

Joy because you uninstalled that patch or because you found the work-around (or
both)???

I'm slightly confused.

 

[Dick Watson]

I uninstalled the broken patch and repeated my copy/paste workflow
successfully.

 

[Dave Peterson]

Ahh.

Thanks for posting back (again!).

I uninstalled the broken patch and repeated my copy/paste workflow
successfully.

 

[eat more bacon]

I had this exact issue today, and was very pleased to come across this thread.

Can anyone explain what the point of preventing this copy/paste was? Also,
won't Windows Update just reinstall the update next time, or is it smart
enough not to do that?

Thanks
Allan

 

[Dave Peterson]

I don't have any actual knowledge about this patch, but I bet it was not an
intended "feature".

And if use Windows update, can't you tell windows that you don't want this patch
installed.

If you have things set to completely automatic, then (to me) it sounds like a
recurring problem.

 

[Jialin Long]

My windows is vista and it always automatically update without asking me. I don't know where the "patch" located but tried to remove my whole office and reinstalled it and it’s not work. I also tried to remove all my windows updates since last Friday. But the problem is still not solved. Is there anyone remove the patch successfully?

 

[Dave Peterson]

In windows XP Home, I can go into the control panel and choose Add/Remove
programs.

Then click the "show updates" checkbox at the top of the dialog.

Then search for the update to uninstall.

(I didn't actually do this. I don't use Access, so I didn't bother.)

 

[anoushka]

I've has this issue for a few days and was glad to find the thread.

I went into control panel, viewed the installed updates and removed the
excel one.

Works fine now.

 

[kapow73]

Accidently found another work around. Copy the data then exit Excel and
when Vista asks if you want to save it say yes. Then you can paste
append into your Access table. At least I have been able too.- Hide quoted text -

- Show quoted text -

This worked for me. I didn't uninstall the patch. I copied, closed
Excel, said yes when it asked if I wanted to save the data on the
clipboard, and then it pasted just fine.

 

[fmsinc]

This worked for me.  I didn't uninstall the patch.  I copied, closed
Excel, said yes when it asked if I wanted to save the data on the
clipboard, and then it pasted just fine.- Hide quoted text -

- Show quoted text -

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