Import dependent

[hawkins]

I have a few columns that I want to populate in a table called Yearly. I have the same columns in an excel file filled with the information and has a column of a list of names 1,2,3,.... which is the same as the list of names in Yearly but the names can be repeated in Yearly because of multiple records for each year for a given name. I was wondering how I could import the table information into the table when it is dependent on the year being 2010 and having the same name? I have never imported in access so you might need to be pretty specific with the answer. Thank you for the future help!

[TheShabz]

Importing an excel sheet into Access is as simple as Ctrl+A, Ctrl+C, Ctrl+V. That will bring in the entire sheet. You can then query for
SELECT excelTable.* INTO newTableName
FROM excelTable INNER JOIN Yearly ON excelTable.nameField = Yearly.nameField
WHERE Yearly.yearField = 2010

I haven't verified the SQL but that's pretty much how it should work.

[hawkins]

thanks for the help, I ended up screwing around with the QBE view and was able to figure it out. The code ended up being:
UPDATE Yearly, Table1 SET Yearly.CalcGrwth = Table1.CalcGrwth, Yearly.PercGrwSummLast5 = [Table1].[PercGrwSummLast5]
WHERE (([Yearly].[Name2ID]=[Table1].[Names3ID]) AND ((Yearly.YearRecorded)=Year(Date())));