I am trying to export 3 different query results to text files. I was trying to use DoCmd.TransferText. However, it is saying that there is formatting file so it fails. I tried creating one, and thought it was going to work cause I could see it in Access, but when run it still failed. Not sure where to go from here.
Code:Private Sub Data_File_Creation_Click() DoCmd.OpenQuery "QueryA", acViewNormal, acEdit DoCmd.TransferText acExportFixed, "ExQueryA", "QueryA", "File Path" End Sub