ACC2000: How to Export the Result of a Query to an ASCII Text File (209692)
The information in this article applies to:
This article was previously published under Q209692 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
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 list box 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. However, the query must contain at least one destination field. This feature is documented in Microsoft Access Help.
NOTE: You cannot type the name of a view or stored procedure in the TableName argument.
REFERENCESFor more information about the TransferText macro action, click Microsoft Access Help on the Help menu, type transfertext action in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 6/24/2004 |
---|
Keywords: | kbhowto kbinfo kbusage KB209692 |
---|
|