O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exporting Data to Other Programs

You cannot export an entire Access database to another program. That's because Access uses all kinds of special organizing methods, like Tables, Forms, Queries, Reports, and Macros, and these wouldn't translate easily into another program.

Besides, if you want to export data, what you really want to export is a table. Tables in Access contain all your data.

Follow these steps to export a table:

  1. Open the database that contains the table.

  2. Click on the Tables tab, and highlight the database you want to export.

  3. Select File, Save As/Export. The Save As dialog box appears (Figure 29.4).

    Figure 29.4. Export your table by saving it in a different format.

  4. Click To an External File or Database, then click OK. The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required