up vote 0 down vote favorite
share [g+] share [fb]

Does anyone know how to get Access 2000 to output a comma-delimited file in this format:

Good> Cat, "John, Doe", 32, $3.44, "Denver, CO", 1234

NOT like this:

Bad> "Cat", "John, Doe", "32", "$3.44", "Denver, CO", "1234"

Only put quotes around the data that contains commas.... not "everything".

I played with the output settings... and even under the "advanced" button... but there doesn't seem to be a solution.

(It works as I need when using Excel, but not when using Access.)

I have no idea which output is the "standard" (if there is one)... but I definitely need to use Access... and I definitely need the "Good" example shown above.)

link|improve this question
1  
There is no CSV standard. There are many slight variations of it. – Zoredache Oct 11 '11 at 0:41
There's no standard, but there's definitely a "standard". (Note the quotes.) Is there a way to output my "Good" style? – Carol Oct 11 '11 at 4:24
Yeah, this is going to be impossible. You are gonna have to dust off the old VBA editor and write a macro. – surfasb Oct 11 '11 at 4:25
I was afraid of that. VBA modules are NOT my idea of fun. I was VERY surprised to see my desired "export format" built right into Excel, but not Access. – Carol Oct 11 '11 at 15:41
You will need to register your account if you would like to make comments such as in this case: superuser.com/questions/335656/… – random♦ Nov 15 '11 at 4:48
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.