Exporting Access 2003 Tables to Excel

A Step-by-Step Tutorial for Access 2003

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. 

Tutorial to Export Access 2003 Tables to Excel

This tutorial uses the Northwind sample database.

If you can’t find it on your system, read the about How to Install the Northwind Sample Database before continuing. 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.

    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.
     
  1. Specify an appropriate filename in the “File name” textbox.
  2. 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. That’s all there is to it!

Note: These instructions apply to Access 2003 and earlier versions.

Format
mla apa chicago
Your Citation
Chapple, Mike. "Exporting Access 2003 Tables to Excel." ThoughtCo, Aug. 23, 2017, thoughtco.com/exporting-access-tables-to-excel-1019276. Chapple, Mike. (2017, August 23). Exporting Access 2003 Tables to Excel. Retrieved from https://www.thoughtco.com/exporting-access-tables-to-excel-1019276 Chapple, Mike. "Exporting Access 2003 Tables to Excel." ThoughtCo. https://www.thoughtco.com/exporting-access-tables-to-excel-1019276 (accessed December 18, 2017).