David Emerson
davide at dalyn.co.nz
Thu Apr 24 17:17:09 CDT 2003
Thanks for the reply. Unfortunately I am using an adp which doesn't allow the saving of secifications. David At 24/04/2003, you wrote: >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 >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com Regards David Emerson DALYN Software Ltd 25b Cunliffe St, Johnsonville Wellington, New Zealand Ph/Fax (877) 456-1205