Export to Ascii

L

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top