Exporting files

[Kathy MacAthur]

Hi - hope someone can help.

When I go to export query data - some of the fields are not encased in
"quotes ". When I go to import this file info another program it can't
differentiate a number of the fields because of the lack of "quotes". I
realize the quotes are used to differentiae between the different fields but
Access appears to include quotes around some fields but not others. The one
field in particular that lacks the "quotes" is an autonumber used as a
customer number.

Any suggestions. Thanks in advance.

Kathy

 

[Allen Browne]

The quotes are around what Access considers to be text.

If you AutoNumber field is named "ID", enter this expression into the Field
row of query design:
Str([ID])

Access will now export the field as text, with the quotes.