Use Excel's MS Query Wizard to query Access databases

Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program.

There's data in your company's Access database that you need to analyze, but the PC you work with does not have Access. No problem! You can use Excel's MS Query Wizard to come up with the answers you need. For example, suppose you need a list of customers with outstanding balances, and the data is in the Customer table of your Sales database. To get the customer list, follow these steps:

  1. Open a new blank Excel worksheet.
  2. Go to Data | Import External Data | New Database query.
  3. Under the Databases tab, select MS Access Database and click OK.
  4. Under Database Name, select Sales and click OK.
  5. Click the Customer table.
  6. Click Customer No. and then click the right arrow box.
  7. Click Name and then click the right arrow box.
  8. Click Balance and then click the right arrow box.
  9. Click Next.
  10. Select Balance from the drop-down menu.
  11. Select Is Greater Than from the drop-down menu.
  12. Select 0 from the drop-down menu.
  13. Click Next.
  14. Under Sort By, select Customer No. and click Next.
  15. Click the Save Query button, then click Next.
  16. Click Finish.
  17. Click Existing Worksheet, and then click OK.

The results of the query will be displayed in the blank, open worksheet.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox