:confused: I have a database of historical baseball data.

It contains 5 tables:
Players: (Full Name, Last Name, First Name, Primary position)
Year: (Single field, w/autonumber)
Data: (many fields of specific data)
Position: (C thru DH)
Team: (1-30)

Each table has a unique key, (auto-generated)
The database contains 4 years worth of specific data, (2003-2006)
The main data table has lookups to the other tables built in to the current table

First run through shows the DB to operating pretty efficiently, (although more time will tell more, NOTE: I am a level 2 rookie).

PROBLEM:
I now need to import/update/append the tables with 2007 projected data, and then at the end of this year coming up, I will need to do the same with actual data, and so on.......

The data that is coming into the DB does not contain MATCHING PRIMARY KEY:
The Team Name, (with age as an added field)
Player Names, (all full,last,first,primary position)
The data, (all fields match name and data type)
Year, (2007, + I will be adding a field that denotes actual or projected).

HOW do I update the tables and assign the primary keys to all the table's matching names while doing so and assign the correct/matching Pirmary Key to the updated records.

HOW do I verify that the update was correct without scrolling through 2500 data rows and 937 players?

Any and all help would be greatly appreciated
Thanks
Doug

Add a new row to the top of the Excel spreadsheet.
Enter the name of the field from your tables to the appropriate row.
Add an extra row marked "Year". You can paste the appropriate year several rows at a time in Excel. Access won't let you do that.
Import the spreadsheet to Access as a table giving it a name like TempPlayer.
Run an append query.