Hi all,
I'm looking to export three separate queries into a single text file.
Currently I have three of them exporting separately (see code below) into the same folder. I was wondering if they can be put one line after another in a text file.
Code:
DoCmd.TransferText acExportFixed, "Xtrakter Export Header Export Specification", _ "Xtrakter Export Header", "W:\Markets & Investments\Sam's Folder\XtrakterHeader" & Format(Date, "DDMMYY") & ".txt", False
DoCmd.TransferText acExportFixed, "Xtrakter Export Body Specification", _
"Xtrakter Export Body1", "W:\Markets & Investments\Sam's Folder\XtrakterBody" & Format(Date, "DDMMYY") & ".txt", False
DoCmd.TransferText acExportFixed, "Xtrakter Export Footer Specification", _
"Xtrakter Export Footer", "W:\Markets & Investments\Sam's Folder\XtrakterFooter" & Format(Date, "DDMMYY") & ".txt", False
'
Any help would be appreciated.
Many Thanks