Updating Access Lists

[jnesbitt]

I am working with the following products:

Excel 2003
Access 2003

I pull a collection report from Timberline and import it into Excel. I adjust the layout of the worksheet so that the information and headers match my Access database. This is what I need it to do. When I pull this new report weekly and import it into Access, I want it to only insert the names of the new people on the list. In other words, I don't want duplicate entries in my database and their is too much information to input it all manually. Also, I have each set of names divided by market and school (i.e. 350Phoenix-BRY). Can I get it to not only put in the new names on the list, but also put them in their correct market. All my column titles match in the Excel file to the Access file.

Thanks so much!

[XLGibbs]

Set up an additional table and tag it with Import_NewData or something.

You can bring in all the records to this table.

Then create an Append Query which will add the records from this Import table to your other table. provided there is a primary key, it will not add any duplicates.