Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.)

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.