miamirocks
IS-IT--Management
Does anyone know how to export the output of an Access query to a new database table or to a flat text file?
Thanks!
Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting Query Results to a New Table or Text File
- Thread starter miamirocks
- Start date
- Status
Through a macro, first you would open the query using OpenQuery action in the macro and then the next action would be 'Output TO'. In the output to action, you can pick if you want a flat text file or excel or any format you wish. Alternatively, you can do this using make table query.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
