Integrating MS office programs

Hi Melinda

I am taking this to mean you want to get data from Access to use in Excel. So, to import into Excel the data from an Access table you do this:

1. Choose Data, Import External Data, New Database Query. From the Databases tab click the MS Access Database link.

2. Enable the Use the Query Wizard to create/edit queries checkbox then click OK.

3. Select the Access database and click OK to open it.

4. Choose the table to use from the list on the left and click the chevron to move this to the right pane. Click Next to continue. You can now create a query to return only a subset of the data if you want to