I am using, or rather I want to use, the DoCmd.Transfertext method for
trannsferring records to a text file which in turn will be used to send
information to a customer of ours.
DoCmd.TransferText acExportDelim, , "qryEDI_Info", strPathFile
Using the above command works. But I ahve been informed by the people
that will then create the EDI file for the customer that my txt file has
quote marks (") for all non-numeric fields. I am guessing that I can
change that if I create a new specification. Am I correct in that
assumption? If I am correct then can someone please tell me HOW to do
that using Access97.
DoCmd.TransferText acExportDelim, specificationname, "qryEDI_Info",
strPathFile
If I am wrong in my assumption then I could use some guidance in
accomplishing an exported file, comma delimited with no quote marks.
Thank you
[Non-text portions of this message have been removed]