Hi All
I have been trying to code a Delimited Export of a query with TransferText but I specifically need that Export with a Text Qualifier of <none>.
If I do a manual export, I can release the file as I need it but a macro or coded version defaults the Text Qualifier to "".
My code currently is:
DoCmd.TransferText acExportDelim, "", "qryCurrentPostings", "c:\windows\desktop\exports\test.txt", False, ""
Does anybody have a solution or any other code to add to the above.
regards,
Paul
I have been trying to code a Delimited Export of a query with TransferText but I specifically need that Export with a Text Qualifier of <none>.
If I do a manual export, I can release the file as I need it but a macro or coded version defaults the Text Qualifier to "".
My code currently is:
DoCmd.TransferText acExportDelim, "", "qryCurrentPostings", "c:\windows\desktop\exports\test.txt", False, ""
Does anybody have a solution or any other code to add to the above.
regards,
Paul