I need to import specific cells from an excel spread sheet to a table in Access 2000. Is there a code to do this?

Have you tried the Link Table option in Access?
This will link in the entire spreadsheet and you can append the data from that link to another table?

let me know if you need more info.

DoCmd.TransferSpreadsheet acImport, , stDocName, "c:\access files\pv.xls", True, "A:D"

note the end has all of colum A through D chosen. You should be able to place in what you want there. like A1:B4 and soforth

Would you do this via creating a new Macro or Module within Access?

I have it in a form to import on a click of a command button. You may be able to find the macro version of it, but I do not know. I do not like macro's prefere to run VBA it makes the size smaller and faster.