I found the answer to my question. Took a bit of work but I discovered where things were finally.
--- In [email protected], "Marty" <[EMAIL PROTECTED]> wrote: > > > 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] >
