Export to Ascii

[Lin]

Hi Folks Need a bit of help. Trying to export a table as Ascii text. There
are three fields - FileID, Surname, FirstName. The last two export fine, the
File ID however, does not have the "". I am selecting Delimited ".
I
I've tried using Chr(34) & [FileID] & Chr(34) it doesn't work.
I am however using Access 2003.

Any help would be great

Thanks folks

 

[John Spencer (MVP)]

If fileId is a number field, then it would not be surrounded by quote marks.
That is the normal specification.

If you need to have the quote marks try exporting a query instead and use a
calculated field for fileID of FileID & "" or CStr(FileID)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County