Appending from excel into 2 tables

[teiben]

I need assistance, the lookup won't work after doing the append, advice?

2 tables Users & Scores

Users
name, dept & IDStudent (primary autonumber)

Scores
IDStudent (primary number) w/lookup to users SELECT [ID] AS xyz_ID_xyz, [Dept] & ', ' & [Student Name] AS xyz_DispExpr_xyz, [Dept], [Student Name] FROM Dept ORDER BY [Dept], [Student Name];
Q1, Q2, etc

I will have to frequently import into access from excel; I've tried appending but then my lookup doesn't work, doesn anyone have any idea's how to do this?

 

[DCrake]

A copy of the spreadsheet would be helpful as we can then see both sides of the problem. Can you provide sample xls?

David