Quick Tutorials: Exporting a Query from Ms Access 2003 /2007

Taking into consideration that the tables and queries are done:
  1. If the query is not closed, close it.
  2. Right click on the query and click “Export”
  3. A Dialog Box will appear asking where to export the specific named query to. Locate where you want to place the exported file then
  4. Go to the “Save as type” drop down and select the “Microsoft Excel 97-2003 (*.xls)” option first (or whatever version you are using)
  5. The name of the query should automatically pop up in the “file name” box.
  6. Click to check the box next door to “save formatted”
  7. At this point if you are going to directly work on the file then you also click in the check box for it to “Auto start”
  8. Clicking “Export” would then automatically bring up the exported Excel file after which you are free to select your information and create your charts.


For more tutorials like this please feel free to visit I.T University Resources by click ing the link under Bookmarks located to the top right of the page.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s