469,315 Members | 1,592 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

exporting query data as txt comma delimitted.

i know I'm going mad. I did this just a couple of weeks ago, now I can't get anything in the export window to let me send query results as a comma delimited txt file. I'm new to access but i thought i could follow logic paths - oh help and bother.
tigger

OH RATS - NEVER MIND - IT WAS A PROB FROM 3 QUERYS BACK.
SOMEDAY SOMEONE WILL HAVE TO TELL ME WHY THEY LIKE THIS MESS. LOL
Jul 5 '08 #1
1 1044
nico5038
3,080 Expert 2GB
I like this mess, as you're punished for every mistake, but rewarded when having everything right.

For your export you can use a button on a form with a single line of code using the DoCmd.Transfertext command. Thus once recorded, every next execution will function flawlessly :-)

Nic;o)
Jul 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Fran Zablocki | last post: by
3 posts views Thread by | last post: by
3 posts views Thread by David P. Donahue | last post: by
4 posts views Thread by Katie | last post: by
reply views Thread by =?Utf-8?B?ZGVuIDIwMDU=?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.