Importing Excell data into a access 2007 personal contact manage

Hi Paul, there's a much better way of performing this task:

1. format the excel sheet to the same format as the table in Access.

2. Go to the import office button and link to the sheet that you are trying to import.

3. Once the link is complete, you should now be able to see the excel sheet as an object within the navigation panel.

4 Create a new query, drag the newly link excel sheet into the query pane, then change the select query to an append query.

5 follow the access instructions

6. select the columns you want to update from the excel
sheet and match them to the table you want to update.

7 save the file and run the query.

voila!!!!!