Export Access Query to TXT using DoCmd.TransferText Method. The below Procedure exports Query1 to the C:\test\ folder. The file will contain field name in the first row. Public Sub export_query() DoCmd.TransferText transferType:=acExportDelim, TableName:="Query1", FileName:="C:\test\Query1.txt", hasfieldnames:=True End Sub