Exporting Access Tables to Excel

Tutorials Shared by the Internet Community

Advertisements


Synopsis

It is often necessary to convert data stored in an Access database to another form.

Statistics

  • Total Hits - 26897

  • Total Votes - 102 votes

  • Vote Up - 46 votes

  • Vote Down - 56 votes

  • Domain - databases.about.com

  • Category - MS Access/Excel Interaction

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 07:05:04

Description

It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick. Let’s take a few moments to walk through the process, step-by-step. For consistency’s sake, we’ll continue to work with the Northwind sample database. If you can’t find it on your system, read the article How to Install the Northwind Sample Database before continuing with this tutorial. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements