I have very little understanding of Access but I think what I am trying to accomplish is fairly simple.
Using a scripted process, I gather data about servers and the data is dumped into Excel for each location. The format of the Excel spreadsheet is constant. Each location has a new spreadsheet but the headers remain the same.
I would like to build an Access database that "links" into these spreadsheets. This way, as a particular Excel spreadsheet is replaced with an updated version, the Access database does not need to be changed. Simply refreshed.
I have figured out how to "link" the Excel spreadsheets, now I need to combine the data from the various Excel spreadsheets into a single Table
Remember that the headers for all the spreadsheets will always remain the same, only the data will change.
Any insight would be greatly appreciated.
Using a scripted process, I gather data about servers and the data is dumped into Excel for each location. The format of the Excel spreadsheet is constant. Each location has a new spreadsheet but the headers remain the same.
I would like to build an Access database that "links" into these spreadsheets. This way, as a particular Excel spreadsheet is replaced with an updated version, the Access database does not need to be changed. Simply refreshed.
I have figured out how to "link" the Excel spreadsheets, now I need to combine the data from the various Excel spreadsheets into a single Table
Remember that the headers for all the spreadsheets will always remain the same, only the data will change.
Any insight would be greatly appreciated.