First, let me start off by saying that I know very little about Access. I am however very good at Excel. My company has 20 years of data in Excel spreadsheets and continue to use them, but we are looking at ways to get that data into a database so it can be queried and used to generate reports if needed. Our data is all numerical, things like time/date, temperature, etc... I am trying to determine if this is possible so I am trying to work on the most complex spreadsheet we have first. The Excel workbook is for an entire month, with a tab for each day of the month. I have made a new tab to pull data from each day (tab) to compile a monthly table that I want to import into Access. I have played around with it a little and can get each workbook to make a new Table in Access. I have found that Linking to the Data Source would be the most ideal, that way if changes were made to the source data, it would be reflected in Access. What that would look like for the past 20 years worth of data is 240 linked tables, plus a new one each month. I am okay with that, but what would be the best way to get all that information into one Table? Each table has the same 46 fields, so they all match up. Thanks!