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:
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)