Data in a Microsoft Access database will already be stored in tables. When you fetch the data, you will need to identify the table to import. If the database is a relational database, you may need to fetch the data from a query that combines data from different tables. To get data from a Microsoft Access database: Select the cell where you want to insert the data On the Ribbon, click the Data tab In the Get External Data group, click the From Access button The Select Data Source dialog box will be displayed – this is similar to a standard Open dialog box. Locate and select the database file, and then click Open The Select Table dialog box will be displayed. In the list, choose the required Table or View Click OK The Import Data dialog box will be displayed. If you just want the table data in the worksheet, choose Table – otherwise choose PivotTable Report or PivotChart and PivotTable Report as required Using the Where do you want to put the data options, make sure that the correct cell is chosen, or alternatively choose New worksheet Click OK The data will be imported into the Excel worksheet. It will be formatted automatically as an Excel table. A connection to the data source will probably be established, but security settings on your computer could prevent this.

You can fetch data from a web page. The web page needs to include information formatted in a table format using the html table tags.

If a web page has a table clearly laid out, it is relatively easy to select it and import it into Excel. However, web pages may also have tables embedded inside tables, which are embedded in other tables, etc. – this can make it harder to retrieve the data.

If no table exists on the web page, you can still fetch the details from a whole web page.

To get data from a web page:

Select the cell where you want to insert the data

On the Ribbon, click the Data tab

In the Get External Data group, click the From Web button

Assuming that you have access to the internet, the New Web Query dialog box will be displayed, and your default home page shown.

In the Address box, type the required web page address, and then press Enter

For each individual table that Excel finds on the web page, it will show a small black and yellow arrow icon.

Click the small black and yellow arrow icon for the table of data that you want to import – if you click the very first one, the whole page will be selected

To select multiple tables, hold down the Ctrl key, and then select each table

When you are ready, click Import

The Import Data dialog box will be displayed.

Using the Where do you want to put the data options, make sure that the correct cell is chosen, or choose New worksheet

Click OK

Excel will attempt to download the data from the web page. The layout of the imported data will depend on how the table on the web page is constructed.

A connection to the data source will probably be established, but security settings on your computer could prevent this.