Access Error: Data on the Clipboard is damaged, so Microsoft Access can't paste it

Symptoms
When performing a copy/paste operation from Microsoft Excel into Microsoft Access, you receive the error "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." when the following 2 conditions are true:
  • One of the values in the first row of data contains a decimal point
  • You copy more than one row of data

Cause
Microsoft is aware of this problem in recent versions of Microsoft Access.


Resolution
Use one of the following workarounds:

Method 1

In Microsoft Access, click the dropdown arrow on the Paste icon and choose Paste Special. Select either Text or CSV.

Method 2

Ensure there are no decimal points in the first row of the Excel data you copy.

Method 3

Copy and Paste a single row at a time.
More information
The problem does not occur in Microsoft Access 2003.

Steps to Reproduce

1. In Access, create a new blank database
2. Create a new table in table Design View
3. Add the following field:
Name: Field1
Data Type: Number
Field Size: Double

4. Save the table as Table1
5. Open Table1 in Datasheet View
6. In Microsoft Excel create a new spreadsheet
7. Add these values to the following cells:
A1: 83.9
A2: 3020
8. In Excel select A1 and A2 and click the Copy icon
9. In Access select Field1 and click the Paste icon.

Result

 You receive the one of these versions of the error:
  • 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.
  • 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.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2221635 - Last Review: 10/01/2015 03:05:00 - Revision: 4.0

Microsoft Office Access 2007, Microsoft Access 2010, Access 2016, Microsoft Access 2013

  • KB2221635
Feedback