Re: Export problems

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Garry" <garry.fitzgerald@xxxxxxxxxxxx> wrote in message
news:e%JYi.21563$Eq.1362@xxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Exporting Data as text file
    ... To have the spaces replaced with zeroes, write a query that uses the Format ... function on the numeric fields (not the Format property), ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.externaldata)
  • Re: Export Currency to a Flat File
    ... Create a query that uses the Format function on that field, ... Doug Steele, Microsoft Access MVP ... > in the Access file), but when the number is something like 34.10, it ...
    (microsoft.public.access.externaldata)
  • Re: Access 97 Export to text dropping decimal spaces
    ... Try creating a query, and use the Format function on the field. ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.externaldata)
  • Re: List Box Format of Phone Number
    ... Create a query based on the table, and use the Format function in the query. ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help on zero field
    ... The data file of mine contains 5 different numeric fields ... a query based on the table instead of just the table. ... query can use the Format function (or other string ...
    (microsoft.public.access.queries)