Excel import data

Hi Mofe

Sorry for the delay in answering this question

To import data from Excel into Access do the following:

Make sure that the data on the spreradsheet you are importing starts with the field names(column headings) on row 1. This is so that when you import the data into Access it converts the values in this row into field names.

1. Select File, Get External Data and click Import

2.The Import dialog box appears

3. In Files of type select Microsoft Excel. Find the relevant file and click Import

4. The Import spreadsheet wizard appears. Select First row contains column headings. Click Next.

5. Select where the data is to go. Click Next.

6. Specify the information in the field and also determine if the field is to be imported. Click Next.

7. Set the Primary Key. Click Next.

8. Set the new table's name. Click Finish.

Hope this helps.

Carlos