Hi everybody
I am new to Access and have been asked to take an Excel workbook with several tabs (each with around 10 fields) and put that data into an Access database instead. To make my question easier to understand, I have attached an example of the Excel template, rather than me butchering the explanation by trying to write it out instead!
I have looked around the forum and elsewhere for an answer and have not found one yet - so I am sorry if it is here somewhere and I haven't seen it.
Where I am running into trouble is that, although each of the county worksheets in the spreadsheet has fields in common (State, county) etc., they are not unique.
I am wondering what is the best way to set up an Access database with this excel data. I assume the tables can be linked and some duplication between each of them removed as the counties and states and product hierarchies are the same in each table. This is why it is supposed to be a better way of storing the data than in Excel.
Hopefully somebody can help. Let me know if this needs explained further. Thanks so much!
I am new to Access and have been asked to take an Excel workbook with several tabs (each with around 10 fields) and put that data into an Access database instead. To make my question easier to understand, I have attached an example of the Excel template, rather than me butchering the explanation by trying to write it out instead!
I have looked around the forum and elsewhere for an answer and have not found one yet - so I am sorry if it is here somewhere and I haven't seen it.
Where I am running into trouble is that, although each of the county worksheets in the spreadsheet has fields in common (State, county) etc., they are not unique.
I am wondering what is the best way to set up an Access database with this excel data. I assume the tables can be linked and some duplication between each of them removed as the counties and states and product hierarchies are the same in each table. This is why it is supposed to be a better way of storing the data than in Excel.
Hopefully somebody can help. Let me know if this needs explained further. Thanks so much!