Export Query To Comma Delimited Text File

[jawilli1]

Hi Yall,
I have query called qryfadmpcol that I want to directly export out to a comma delimated text file using VBA. I've found stuff about tables for this but I havne't found anythign for a query. Any ideas? A code snipit would be helpful.

Thanks!

 

[FoFa]

Query, Table same thing as far as what you are doing is concerned.

 

[modest]

Same code for query as for table, but instead of table name use query name

Example:
DoCmd.TransferText acExportDelim, , "Query Name", "File Name Exporting To.txt", False

 

[jawilli1]

Great! Thanks that worked like a charm!

 

[access17401]

I know this is a very old question, but in this how would I define the export location?