You need to go through the export process manually and create a specification as you do so.Use the Advanced button on the export dialog.You can then create a macro or code procedure using Transfertext in which you use the specification.

Great! Thanks! I forgot I've used that in the past. (a long time ago).One final question, do you know if it's possible to have it change the file name when it's run? This is for a report to generate a file each month. The file name is required to have the month, that the data represents, in the name...is there a way to automate that or is it best to have the user make that change each time it's run?

If you use docmd.Transfertext in code then you can build the filename from expressions.You can't do that witha macro.ocmd.TransferText acExportDelim,"spec","queryname","C:\folder\File" & format(date(), "yyyymmm") & ".txt", true