Error Copying & Pasting from Excel

[kristyspdx]

We just upgraded from Office 2007 to 2010. I have a procedure I run every day where I copy and paste some information from Excel into a table in Access. This worked fine before we upgraded, but I now get the following error: The Microsoft Access database engine could not find the object '[Sheet1$R1C1:R65C18]'. I am able to copy and paste the data if I put it in a new spreadsheet first, but it's kind of a pain. Anyone have ideas on how to resolve this?



Thanks.

[kristyspdx]

I have figured this out. If you are copying & pasting from an Excel worksheet that is already in existence, you must save the file before you can copy & paste anything into Access from a new tab. Weird...never had this problem in Access 2007. If you are copying & pasting a from a new Excel worksheet, there is no problem.