Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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:… – random Nov 15 '11 at 4:48

You must log in to answer this question.

Browse other questions tagged .