Linked Table problem

[mrchonginhk]

Today I have 10 linked table, tomorrow I need it increased to 11, tomorrow 12, ... and growing...

How to resolve this issue in Access ? Now I have to add them manually.
Is there way to do this dynamically ?

Thanks

 

[james_lankford]

so at the end of the year you're going to have 365 linked tables ?
with exactly the same structure ?

 

[SydneyGeek]

Why not add the data to a single table? Create a field with a date identifier so you know which day the data relates to. That can be populated on import.
If you add a new table every time your data changes you will have to change any queries that analyse that data. That is not an efficient way to work.

Denis