Export problems

[Garry]

Hi

I need to export:- databases, queries and reports

My client has specified that all data be comma delimited and with quotation
marks even though some fields are numeric

They require for example a plain text file in the form of:-

"John","Jones","36"
"Mike","Smith","22" etc

I am using access 07

Can anyone please solve this for me, have spent hours exporting without
success

Many thanks, Garry

 

[Douglas J. Steele]

Create a query and use the Format function in the query to convert the
numeric fields to strings. (The function, not just setting the Format
property of the field)