Error pasting Excel sheet into Access 2k

[TheRealDJ]

Hello all.
I have Office 2000 and am always trying to copy tables created/modified in Excel and paste them into Access as new tables.

When I select the "PASTE" option in Access, I get past the window that asks "Does the first row of your data contain column headings?"

And always get confronted with this:

"The MS Jet Engine could not find the object SheetName$R1C1:RxxC2.
Make sure the object exists and that you spell its name and the path name correctly."

The cells it identifies are similar to the boundaries of whatever table I'm trying to copy.

I've tried updating the MS Jet Engine to a different version, but I still get the same error.

Can anyone help in identifying the culprit?

Thanks.

David J

 

[Bariloche]

David,

Don't paste the table. Import it. Right click in the Access "Table" pane, select "Import..." and follow the wizard. Your Excel spreadsheet needs to be saved first (I believe).

enjoy

 

[TheRealDJ]

Thanks. I've always been able to Import using the "Import From" function.

Since I use several small tables, it's alot easier copy/pasting from Excel to Access, especially when they're just for quick comparision to other tables.

Has anyone else had a similar problem in the Copy/Paste function?