ACC: How to Export the Result of a Query to an ASCII Text File (94929)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q94929
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
This article shows you how to use the TransferText macro action to export
the results of a query to an ASCII text file.
MORE INFORMATION
The TransferText macro action does not specify that you can use query names
in the TableName argument of the action. The argument does not use a
drop-down list with table name choices; therefore, you are not limited to
using table names. By using the name of a query in the TableName argument
of a TransferText action, you can export the results of a query to text
files. This feature is undocumented in Microsoft Access 2.0, but is
documented in the Microsoft Access 7.0 and 97 Help Indexes.
REFERENCES
For more information about the TransferText macro action, search the Help
Index for "TransferText Action," or ask the Microsoft Access Office
Assistant.
| Modification Type: | Major | Last Reviewed: | 5/9/2003 |
|---|
| Keywords: | kbhowto kbusage KB94929 |
|---|
|