470,588 Members | 2,141 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,588 developers. It's quick & easy.

Exporting with text qualifiers - number data

kim
Hello! Here, in brief, is my problem.

Access 2002. I need to export to a csv text file with text delimiters
on every field. I find that if I save the original data in Excel and
make sure the data format selected is text it, when I open it in Access
and try to export it will put the quotes around all the string data,
including null values, but will not put quotes around the numeric data.
Anyone have any ideas on how I can force it to put the text qualifiers
on every field?

Thanks in Advance.

Nov 13 '05 #1
1 4222
Create a query, and use the Format() function to force the numbers into
string format. Then export the query, and Access will put quote marks around
the numbers.

Example of what to type in the Field row of your query to export Field2 as
text:
Format([Field2], "General Number")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ki*@corrupt.net> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hello! Here, in brief, is my problem.

Access 2002. I need to export to a csv text file with text delimiters
on every field. I find that if I save the original data in Excel and
make sure the data format selected is text it, when I open it in Access
and try to export it will put the quotes around all the string data,
including null values, but will not put quotes around the numeric data.
Anyone have any ideas on how I can force it to put the text qualifiers
on every field?

Thanks in Advance.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Johnny Meredith | last post: by
3 posts views Thread by Bilgehan.Balban | last post: by
1 post views Thread by Marc Miller | last post: by
reply views Thread by =?Utf-8?B?ZGVuIDIwMDU=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.