G Guest Aug 10, 2007 #1 How do I code a Transfer Text with type export delimited without ending up with double quotes? Thanks!
How do I code a Transfer Text with type export delimited without ending up with double quotes? Thanks!
P pietlinden Aug 10, 2007 #2 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.
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.
G Guest Aug 10, 2007 #3 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?
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?
