exporting data with commas separating the data

[ceb]

Hopefully this is an easy question? Seems like it should be but I'm
very beginner at this.

I'd like to export the records from a query so that they have an actual
comma between them (exporting as a .csv only puts each record in a
separate row when opened in a text program or excel).

For example:

ID#
1
2
3

would export as:
1, 2, 3,

Any help would be greatly appreciated.

Thanks!

Carol

[steve.minnaar]

DoCmd.TransferText acExportDelim, , "Table1", "MyFile"

strings are formatted as "content",
numerical values are formatted as value,

e.g.
1,"A","B","C"
2,"D","E","F"
3,"G","H","I"

MS Access - A legend in it's own time.
*** Sent via Developersdex http://www.developersdex.com ***

[ceb]

Ok, If I understood you right I tried it and it still produces
something I don't want.

Wouldn't your example be more like:

First name Middle Name Last name
Bob John Smith
Larry Ed Taylor
Tom Lee Jones

1, "Bob", "John", "Smith"
2, "Larry" "Ed" "Taylor"
3, "Tom", "Lee", "Jones"

What I want is, for example:
1, "Bob","Larry","Tom"

Is that more clear and is this different from what you suggested?

Thanks for the help

Carol

[steve.minnaar]

OK, if I understand you the following table

1, "Bob", "John", "Smith"
2, "Larry" "Ed" "Taylor"
3, "Tom", "Lee", "Jones"
4, "Bill", "Bobby", "Thorne"

Should produce the following output?
1, "Bob","Larry","Tom", "Bill"
2, "John","Ed","Lee","Bobby"
3, "Smith","Taylor","Jones","Thorne"
MS Access - A legend in it's own time.

*** Sent via Developersdex http://www.developersdex.com ***