4TOPS Excel Import for MS Access 2000 - description from Softdepia.com:
4TOPS Excel Import Assistant is an add-in for Microsoft Access. It enables you to import data from Excel in Access in a controlled way. Moving row after row through your Excel table(s) you can instantly fill in missing data or alter erroneous data before transferring them to your database. The Excel Import Assistant is a time saving alternative to either writing an ODBC query on Excel as a data source or retyping all the data.
4TOPS Excel Import Assistant is useful in the following situations: You have to fill a Microsoft Access database with data from records and accounts which were previously kept in Excel. The assistant will help you to transfer different parts of the spreadsheet to different tables, fill in missing data and find and replace incorrect data.
You have already data in your Access database but you have to add data to a new column which have been delivered to you in Excel. E.g. adding EAN codes. Use the Find to go to the corresponding Access record, followed by Replace.
You obtain data from different sources using mail and Excel attachments. The add-in remembers which file to open (or location where the file can be found) and the mapping of Excel columns onto Access fields. After selecting the settings previously saved you can start transferring the data into the Access table.
4TOPS Excel Import for MS Access 2000 is a "Free to try" program. You can download and try it for an evaluation period.