Excel allows you to retrieve data from the Web via Web queries by using the From Web feature on the Data Ribbon. With a Web query, you can retrieve data from a single table, multiple tables or all of the text on the Web page. Once the data is retrieved, you can refresh the data with Refresh All command on the Data Ribbon.
To Retrieve Data from the Web with a Web Query
- Click the Data tab on the Ribbon.
- Click the From Web button on the Get External Data group.
- Type the Address of the web page in the Address box.
- Click Go.
- Click the Yellow Arrow next to each table you want to import.
- Click the Options button on the Address bar to select the format of the imported data.
- Click the Import button.
- Specify the cell where you want the web data to be placed.
- Click OK.
Similar Posts:
- Creating a Refreshable Web Query in Excel
- Importing Data from Excel
- Modifying Query Joins in Microsoft Access
- Creating a SQL Query in Access 2007
- Create a Parameter Query in Access
- Restoring Outlook Data from a Backup
- Using Data Macros in Access 2010
Comments on this entry are closed.