access+training - Uploading data from excel

Hi Zehra

If you have data on an Excel worksheet that is needed in an Access Database you import the Excel table. To do this :

NB Before doing this make sure the table being imported from Excel is correctly setup. (ie Row 1 must contain the Column headings / Field names)

1. Open the File Menu and select Get External Data. In the sub menu select Import

2. The Import dialog box appears

3. Find the folder that contains the required Excel workbook

3. In the Files Of Type select Excel

4. Select the name of the Workbook to be imported
5. Click Import

6. The Import Spreadsheets Wizard appears. Go through to the finish and fix anything that is required.

7. When done click Finish

A new table appears in the database.

Hope this helps

Carlos