Looking for some answers to general questions. Access Newbie

[Grefcon901]

I have Posted earlier this week looking for help and @Ajax (Francis) helped graciously, but I am now a bit lost.




"I am currently attempting to build an Access database linked to 21 sheets ( thus 21 tables) that are all identical by column but obviously not all the same data. Data format and dimensions are all the same. Each sheet is a specific stock and holds historical data (open close high low...) by date ascending and a lot of the actual work has already been done by the excel workbook." (earlier post)
All of this is for ETF Tracking so the End of Day data needs to be updated but I really do not want to manually imput it. links to the work book are what i was using but now that I am supposed to put it all in one table im confused. I am not sure how to correctly set the relationship between the Symbol and that specific days price when all of the contents are now just randomly in a list. Do I need to give each symbol its own feild?

Thanks for helping the incompetent.

[ranman256]

import all the sheets into 1 table. Now you can do a search on any historical value.
Every time new data is created , import that sheet onto the pile. (no need to keep importing historical data)

[Grefcon901]

I probably needed to clarify, I need to import the current days data every day. The sheets already acquire the data but Linking always seems to be an issue.
The other part is that I am unsure how I'm supposed to tell which "day low"(example) goes to what symbol.