Elizabeth
ecarey at myway.com
Thu Apr 24 12:04:48 CDT 2003
Hi, You could manually create your export once, and when you do so, create and save an export specification (click the advanced button) with whatever settings you like. Then, in code, use that export specification to export your text file. I do not have AXP to test this on at the moment. Elizabeth DoCmd.TransferText acExportDelim, , "ttmpAgedDebtorDDebitExp", strFullName to export a table but I have quote marks around the strings. Is there some setting so that I avoid the quote marks? The following is no good because it puts all sorts of lines in the file to imitate the boxes around the data. DoCmd.OutputTo acOutputTable, "ttmpAgedDebtorDDebitExp", acFormatTXT, strFullName Regards David Emerson DALYN Software Ltd 25b Cunliffe St, Johnsonville Wellington, New Zealand Ph/Fax (877) 456-1205 _______________________________________________ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com