Put quotes around fields for an export

[Steven Britton]

I have a report that I need to export to a txt file (or
dat file), but I need each of the values to be enclosed in
Quotes. How can I get the quotes around these and how do
I export these to save to the harddrive?

 

[Wayne Morgan]

The DoCmd.TransferText method will let you export a table or query to a text file. It will
export text with quotes around it and other items without quotes. You could create a query
just for this export with calculated fields for the non-text fields, changing them all to
text fields for the output of the query.

Example:
Expr1:CStr(Nz([Field1],""))