Hi Guys
The following line of code exports the file in comma separated format but not sure what change needs to be made to export it in pipe delimited format. Any help will be much appreciated.
Thanks
The following line of code exports the file in comma separated format but not sure what change needs to be made to export it in pipe delimited format. Any help will be much appreciated.
Code:
With db.CreateQueryDef("QryTest", strsql) ' create a temporary query named QryTest
DoCmd.TransferText acExportDelim, , "QryTest", FileName:=strFull, hasfieldnames:=False 'execute the transfer text
End With
Thanks