ACC: How to Export the Result of a Query to an ASCII Text File

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

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.

Keywords : kbusage McrActn
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbhowto