Importing files

Hi Natalie

To Import a worksheet to a database as a table you do the following:

1. Select File, Get External Data and click Import
2. In the Import dialog box, select Files of Type Microsoft Excel
3. Find the excel file you require and click Import
4. In the dialog box select the worksheet which you want to Import
5. In the next window select First Row Contains Column Headings (NB Your column headings in the Excel sheet should be in row 1 for access to recognize those names as the field names
6. Click Next
7. Change the table name if required
8. Click Finish

Your Excel table has been imported

Hope this helps

Carlos