Transfer Text export without double Quotes

[Guest]

How do I code a Transfer Text with type export delimited without ending up
with double quotes?

Thanks!

 

[pietlinden]

How do I code a Transfer Text with type export delimited without ending up
with double quotes?

Thanks!

Go to File, Export and then create an export specification. Set the
text qualifier to {None}. Then once you've named/saved your
specification, include it in your macro/code that does the export.

 

[Guest]

Thanks. I was thinking about that but I don't know how to fit the export
specification name into the following code:

DoCmd.TransferText TransferType:=acExportDelim,
TableName:="qryCollectionsExport", FileName:=txtFName.Value
MsgBox "Export complete. Please transfer file to collection agency.", ,
"Collections Export"

Can you help?

 

[Guest]

Nevermind. I tried what seemed logical and it worked.