[AccessD] Export Text Without Quotes

Hi Paul,

It is because I am using an ADP and not an MDB.

David

At 12/08/2008, you wrote:
>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