Quackit Logo
$1.99 Domain Names
With every new non-domain purchase thru ZappyHost, you get a domain name for only $1.99.
Create free Flash websites

Convert Access Database to Excel

Print Version

A very common question many people have when learning Access is "how do I convert an Access database to an Excel spreadsheet?".

What they usually mean is, "how do I export the data from my Access database to an Excel spreadsheet".

Often they want to do this because they need to distribute the data to someone else who may not have Microsoft Access. Also, in most cases, it's better to send someone a simple spreadsheet containing exactly the data they require, than to send them the whole database and then say, "run the Individual query".

In any case, it's very easy to export data from Access to Excel. You can either export the contents of a table, or the result of a query.

Here's how you go about doing this.

  1. Click on the table or query that contains the data you want to export
  2. From the "File" menu, click "Save As/Export"
  3. Select "To an External File or Database"
    Convert Access to Excel spreadsheet
  4. Choose a location for your Excel spreadsheet (or double click on an existing one)

You now have an Excel spreadsheet containing the data from your query that you can email to anyone you like.

Enjoy this website?

  1. Add this page to your Favorites
  2. Link to this page (copy/paste into your own website or blog):
  3. Help support Quackit by making a donation

Oh, and thank you for supporting Quackit!

FREE Hosting!
With every domain you register with ZappyHost you get FREE hosting.
Need Website Content?
Get unique, quality digital content for your website.
  • 270+ Website Templates
  • 800+ Flash Templates
  • 25,000+ Images, Logos
  • 30,000+ e-Books
  • 15,000+ Scripts
  • 27,000+ Animated GIFs
  • 21,000+ Ringtones
  • ...and much more!
Get your content now!
© Copyright 2000 - 2010 Quackit.com