[ms office - 2007] MS Access Bizarre Paste Problem

[RabbieBurns]

I have a database that requires me to copy data from a spreadsheet into a corresponding table in Access. Its a .mdb created in 2003 but I use 2007.

 

Ive never had a problem before, but today when trying to update the table with new data I was getting this error:

 

http://www.peninsulafm.com/error.PNG

 

Ive never had that before, and have done this same procedure without a problem for over a year and a half now.

 

It did let me paste into a new table, and then from that new table to my existing table, but just not directly into the existing table.

 

Tried it on a few machines as well with the same problem, and even tried a few various backups of the database too to see if something had corrupted somewhere along the lines.

[RabbieBurns]

Oops, ive obviously overwritten the original screenshot with a different one, so disregard that above.

 

Anyway, turns out this is the problem:

 

The Data on the Clipboard is damaged, so Microsoft Office Access can't paste it

 

with some workarounds.

 

Its mentioned in the KB article here:

 

MS08-074: Description of the security update for Excel 2007: December 9, 2008

 

In case anyone else is looking for an answer to this problem.