Excel file appended weekly

[BISHthetiger]

huge brain-fart getting started here. Have weekly Excel file of sales by store by model as below:
Model, SOH, Sales, In Transit, Store
Have to add period(Yr,Month,Week#)to separate each weeks data.
When used Access Import wizard & split first file into linked tables: tbModel, tbStore, tbPeriod (Yr,Month,Week#,tbWeeklyData(SOH,Sales,InTransit); I now am lost on how to append in the next weeks file?
Any help greatfully appreciated
Cheers, Bish

 

[Remou]

Have you considered linking the Excel table and running a selection of Update and Append queries?