Transfer Text export without double Quotes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
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.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Table to Text file including Fielnames 2
Export Spec Problem 1
Exporting Double without Decimals 3
Exporting text files 5
Export Delimited 1
News USB4 announced, will double data transfer speed 3
Export query to tab delimited text file 5
Export to Tab delimited text file 4

Back
Top