O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

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 from Access Tables

You can export data contained in Access tables in any format you can use to import data. The most common export operation with PC RDBMSs is the creation of mail-merge files, used with word-processing applications and spreadsheet files, for data analysis. In most cases, you might want to export the result of a query, enabling you to select specific records to export rather than the entire contents of a file. Exporting tables created from action queries is discussed in Chapter 11, "Using Action Queries."

▸▸See Joining Tables to Create Multitable Queries

▸▸See Creating New Tables with Make-Table Queries

Exporting Data Through the Windows Clipboard

If a Windows application is to use your exported data, the simplest ...

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