Excel Web query files are useful when you want to download real-time data from a website. These files are obtained when you import information from the Internet and download the data into the Excel workbook. The Excel Web query can be updated manually or set to automatically update the downloaded Web data automatically. Use the Access import feature to import this real-time Web query into your database as an imported table.
- Skill level:
Other People Are Reading
Open Excel 2010 and click cell "A1." Click the "Data" tab and select "From Web." A Web browser opens. Type the website that contains the downloadable data in the address bar. For example, you can visit the Yahoo financial section or the ACC sports Web page. Navigate the website and look for a yellow arrow pointing right. This is the import data indicator. Click the yellow arrow and it will become a green check symbol. Click the "Download" button. The "Import Data" dialogue box appears.
Click "Existing Worksheet" and cell "A1" in your workbook. Click "OK." The Web query is imported into your Excel workbook. Save your changes by clicking the "Save" icon on the quick access toolbar. Type a name for your file and click "OK."
Open Access 2010 and click the "File" tab. Click the "Open" button and select a database from the recently used databases in the file menu. The database opens.
Click the "External Data" tab and select "Excel" from the "Import & Link" group. The Get External Data dialogue box appears. Click the "Browse" button and search for the recently saved Excel Web query. Click the file and select "Open." Select "Import the source data into a new table in the current database." Click "OK." The "Import Spreadsheet" wizard opens.
Click the worksheet that contains your Web data. Click "Next." Click "First Columns Contains Column Headers." Click "Next." Type a name for your imported table. Click "OK." Access sends a confirmation message regarding the success of the imported file. This file is now available to be used in your Access database.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for