Convert Access 2003 Database to Excel
See Microsoft Access Tutorial for a tutorial on a more recent version of Access.
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.
- Click on the table or query that contains the data you want to export
- From the "File" menu, click "Save As/Export"
- Select "To an External File or Database"
- 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.
Update
Since this tutorial was written, there have been many subsequent updates to Access. Here's the latest Access tutorial.
-
Access 2016 Tutorial
This tutorial covers a lot more than was in the 2003 tutorial.
Microsoft Access 2016 is the successor to Access 2013.
Go to Access 2016 Tutorial -
Database Tutorial
If you don't currently have an understanding of how databases work, no worries — I have written a basic database tutorial just for you!
This tutorial covers the basic concepts of databases, and the examples use Microsoft Access, so that will make it easier for you once you return to the Access tutorial.
Go to the Database Tutorial