You MUST use an Export Specification to change the commas to TABs.
Look for the sub header Export Access Query to TXT using DoCmd.TransferText Method
The command would look like
Code:
syntax ' TransferType, SpecificationName, TableName, FileName, HasFieldNames
Docmd.TransferText acExportDelim, "ExportTabDelim" , "1Farrow", "C:\Users\User\Documents\pigknows\FARROW.txt", False
You must do one export manually, so you can create the export spec and save it. (Remember the export name!!)
Edit-- I should have read slower - missed June's full response...