microsoft access training class - How do I export data form excel to access | Access forum

Hi Eloise

An easy way to do this is to start in Access.
Before you do so, make sure the data in Excel has the column headings in Row 1.

In Access, Click FILE > Get external Data
IMPORT

Then select the Excel file you want to import.

A wizard will start with 4 steps to assist you
1. Choose worksheet to import
2. Tick the box for Column headings in first row
3. Import to NEW Table
4. Alter any field names (you can skip this step)
5. Choose the primary key (let access add a key)
6. Give the new table a name

DONE

Regards

Richard