clipboard Data corrupted, cannot paste in Access

[mtfrazier]

I'm trying to copy data from an Excel 2007 spreadsheet in MS Access 2000
Database but am not able to copy more than one cell of data at a time without
getting an error message saying "clipboard data corrupted, cannot paste in
Access"

 

[Pete D.]

Kind of tricky copy and pasting, I would name the range you want in excel
and import it to a table.

 

[mtfrazier]

Pete,
Here's the deal, in May of this year, I upgraded from MS Office 2000 to MS
Office Pro 2007 and have been copying and pasting without any problems since
then up until this morning when I received the error. Both MS Excel workbook
and the MS Access database have not been converted to the new file format of
Office 2007. The reason being, I use MS FrontPage 2003 for my websites and
it will not accept the MS Access 2007 file extension, only the .mdb of 2000
and 2003. I can copy one cell from the spreadsheet into Access table with no
problems but copying two or more brings up the error message. Let me ask you
a question, should cells that are copied be separated by a comma on the MS
Office clipboard? I only see a space between them, is that the problem?
Mike Frazier