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 ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
