Clipboard damaged error message?

[Coltom]

New Access user question.I want to Copy/Paste append rows of data from an Excel spreadsheet into a query based on the target table. I finally got the paste to work by ensuring that field order and type were the same between the Excel worksheet and the Access query.

But although I can Copy and Paste Append a single line into Access it won't take two or more lines at one time giving the error 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.".

Googling indicates that this is a known bug (support.microsoft.com/en-gb/kb/2221635). The possible workarounds I've read about don't work. Is there a more permanent fix for this? I read something about a dodgy Security Patch that needs to be removed?

 

[CJ_London]

imports from excel has a habit of reinterpreting data into wrong formats - e.g. a date column with no dates in the first few rows will be interpreted as text (zero length string).

some things to consider
rather than copy/paste, look at using the import facility - taking care to ensure columns are typed correctly
or link to the excel table then use an append query


also, you would normally import to tables rather than queries, so try copy and pasting to the table instead
and because of the excel issue, consider saving the file as a .csv file and importing that