Transfer Text export without double Quotes

K

KADL

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

Thanks!
 
P

pietlinden

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

Thanks!
Click to expand...

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.
 
K

KADL

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?
 
Top