[AccessD] Export Text Without Quotes

David,

No idea what is happening there, we are currently using Access XP.  If I
click on a table, the file export, select Text Files
(*.txt;*.csv;*.tab;*.asc) then click Export.  I can click the advanced
button allows me to create & save my export specification.

So not quite sure whats happening at your end, sorry that I can't be more
help.

Paul Hartland

2008/8/12 David Emerson <newsgrps at dalyn.co.nz>

> I have an AccessXP adp which exports the records from a table into a
> txt file.  I use the following VB command:
>
> DoCmd.TransferText acExportDelim, , "dbo.ttmpAgedDebtorDDebitExp",
> strFullName
>
> (strFullName is the full path of the file).
>
> The text file has quotes around the strings.  Is there an easy way to
> create the file without the quote marks (apart from looking through
> the records and writing them to the file)?  I don't seem to be able
> to create a specification as when I run the export wizard the save
> spec button is disabled.
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com