How to Use Web Query Files With Access

Written by emmanuelle douglas
  • Share
  • Tweet
  • Share
  • Email

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:


  1. 1

    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.

  2. 2

    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."

  3. 3

    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.

  4. 4

    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.

  5. 5

    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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.