Follow this way of importing the Excel files into the Access database:
1. Switch to the "External Data" tab in Access and locate the "Import & Link" group. Click on the "Excel" option. The "Get External Data – Excel Spreadsheet" dialog box opens.
2. Click on the "Browse" button and use the "File Open" dialog box to locate the first Excel file you want to import. Click on the "Open" button to return to the "Get External Data" dialog box.
3. Select the first radio button in the set of three choices to set how the Excel data will be used. This option creates a new table in the current database. Click the "OK" button to continue on to the Import Spreadsheet wizard.
4. Click on the "Show Worksheets" button and identify the worksheet you want to use. If your spreadsheet file contains only one worksheet, your choice is simple. If it contains more than one, be careful to select the proper choice. 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. Click on the "Next" button to continue.
5. Click on the "First Row Contains Column Headings" check box to tell Access to use these column labels as field names. You can see the proposed field names in the sample data at the bottom of the wizard. Click on the "Next" button to continue.
6. Click on the first column of your data and use the "Field Options" above the sample data to provide information about the data. Use the "Field Name" box to override the column heading as the field name. Set the "Data Type" drop-down
menu to "Text," "Memo," "Number," "Data," "Time," "Currency," "Yes/No" or "Hyperlink," depending on the column's contents. Use the "Do Not Import Field (Skip)" check
box to omit a column. Use the "Indexed" drop-down menu to indicate whether the field contents should be indexed. Click on the "Next" button to continue.
7. Define a primary key for your data import. By default, Access adds a primary key that it selects. You can override its choice or tell it not to create a key. Click the "Finish" button to continue.
8. Rerun the Import Wizard, this time choosing to append data to your new table and specifying the name of the next file you want to import. Append your data and launch the wizard again for the next file. Repeat this process until you have imported all your
spreadsheet data.
Regards.
