How to Export Access 2003 Tables to Excel

The Microsoft Access logo


It’s often necessary to convert data stored in an Access 2003 database to another form, such as an Excel workbook. You may want to take advantage of some of Excel’s unique analytical capabilities or to share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward. 

These instructions apply to Access 2003 and earlier versions.

Tutorial to Export Access 2003 Tables to Excel

This tutorial uses the Northwind sample database, so you'll need to make sure it's installed. After you successfully install it, follow these steps to export the Customers table to an Excel workbook.

  1. Open the Northwind database.
  2. When the Northwind Switchboard appears, click the Display Database Window button to access the main database screen.
  3. If you are not already in Table view, click the Tables option under the Objects menu on the left side of the Database window.
  4. Double-click the Customers table in the Database window to open the table.
  5. From the File menu, choose the Export option.
  6. You should now see a dialog box titled “Export Table ‘Customers’ To…” Specify the export format by choosing Microsoft Excel 97-2002 from the Save as type menu.
    1. When you browse this menu, take note of the various options in the “Save as type” menu. You can use this same process to export Access tables to a wide variety of forms, including other databases like Paradox and dBASE. Access provides a great deal of flexibility by allowing you to export data to any ODBC-compliant data source or a plain text file.
  7. Specify an appropriate filename in the File name text box.
  8. Click the Export All button to complete the export process.

Once you complete this process, open the Excel spreadsheet to verify that the data was successfully exported.