If you think this thread can help explain or clarify your issue, copy the URL from the address bar of your browser and paste into your thread.
Explain your problem clearly - if the issue is to do with data in a worksheet or formatting, consider attaching a copy of that worksheet that contains sample data only.
If you've created multiple spreadsheets that contain the same data columns, you can combine their contents into one Access file by repeating the data-import process with each individual spreadsheet. Select the first radio button in the set of three choices to set how the Excel data will be used.
For example, if you have a Pivot Table report of expense figures for each of your regional offices, you can use a data consolidation to roll up these figures into a corporate expense report.
The separate worksheet ranges can be in the same workbook as the master worksheet or in a different workbook.
When you consolidate data, you are assembling it so that you can more easily update and aggregate data regularly or as needed.
If it contains more than one, be careful to select the proper choice. Click on the "First Row Contains Column Headings" check box to tell Access to use these column labels as field names. Click on the first column of your data and use the "Field Options" above the sample data to provide information about the data.
Review the sample data at the bottom of the wizard to verify that you chose the correct worksheet and that the first row of the data consists of column headings. You can see the proposed field names in the sample data at the bottom of the wizard. Use the "Field Name" box to override the column heading as the field name.