access courses in london - Importing Tables

Hi Stuart

To import an excel file into Access do the following:

1. Make sure the Excel file is saved in a folder you have access to.

2. Start Microsoft Access and open the database you want to import the Excel information into.

3. Open the File menu, click Get External Data and then click Import.

4. In the Import dialog box, select Microsoft Excel (*.xls) in the Files Of Type option. (This will display only the Microsoft Excel files)

5. Find the desired file and click the Import button.

The Import Spreadsheet Wizard appears and allows you to choose options specific to the file.

Hope this helps

Carlos