The following TransferText method exports from a query and creates a comma delimited file C:\Sales\July.txt with field names:
DoCmd.TransferText acExportDelim, , "qrySales", "C:\Sales\July.txt", True
To have a semi-colon delimited file, you can save a specification name from File, Save As/Export... and type the name in quotes in the second argument in the method.
See Help on TransferText action and method for more info.