Materi Microsoft Access : import data from Excel into a new table

How to import data from Excel into a new table :

1. On the External Data tab, in the Import & Link group, click Excel.
2. In the Get External Data dialog box, click the option Import the source data into a new table in the current database, click Browse to locate the source file, and then click OK
3. In the Import Spreadsheet wizard, select the worksheet or named range that has the data you want to import.
4. Click Next to work through the wizard to specify whether the first column of the data includes column headings, set field options, designate a primary key, and name the table.
5. Click Finish in the wizard, and then select the option Save import steps in the Get External Data dialog box if you want to save the steps in this operation.