Export problems

  • Thread starter Thread starter Garry
  • Start date Start date
G

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
 
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)
 
Back
Top