Pasting info from Excel to Access gets the 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 later.

We have been doing this for a long time but suddenly we are getting this message - intermittently.  Nothing has changed.  Three people have been getting the same message doing the same job.  You can copy and paste successfully one minute and then you will get this message.  We clean the memory, the clipboard, you name it but we still get that message.
 

Question Info


Last updated November 12, 2018 Views 11,691 Applies to:

Follow the easy method to clear clipborad Clear clipboard:

Additionally clear the temp folders

This should solve your issue...best of luck mate !!

BLACK BARRON

 


P.S : Please post back with the status of the issue. If this post was helpful to you, please vote for my post If this post has helped you resolve your issue, please mark my post as answered.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I found this through Google and I tried step one and it worked like a charm...

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

Somewhat of a hassle and hopefully Microsoft fixes this soon.  I use excel and access together all of the time and it is a shame they no longer work as well together.

3 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

https://support.microsoft.com/en-us/kb/2221635 offers several solutions.

A better workaround (in my opinion) is:

  1. Add a blank row at the top of the data you are pasting from Excel
  2. Copy the blank row + the rows of data that you want
  3. Paste into Access.

Since the error appears to occur when pasting certain decimal values in the first row into Access, you should be able to paste the data successfully. Additionally, Access should ignore the blank row.

95 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Wow! You made my day!

Thank you! Have found this through Google and for me it worked fine!

I love you for that one! Started thinking I was crazy!!

Greetings from Germany

Ron

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.