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

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

Id. de artículo: 2221635 - Última revisión: 10 jun. 2010 - Revisión: 1

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

Comentarios