Put quotes around fields for an export

  • Thread starter Thread starter Steven Britton
  • Start date Start date
S

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?
 
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],""))
 
Back
Top