I'm new to this site and just signed in. I'm hoping this can get me out of a hole sometimes that i'm in. I'm very stumped right now and googled for the answer and no luck. But what I'm looking for is how to pull in all values from 1 field in a table and exporting into 1 cell alone in excel.

example:
sql = "SELECT PARENT, KIDS FROM DATABASE"

output:

parent kids
Bob Joe
Bob Mary
Bob Susan


I'm wanting output to be:

parent kids
Bob Joe,Mary,Susan

It's already been viewed by over 50.....I know 1 of you has to know the answer. I found things like CONCAT() or GROUP_CONCAT() but concat was mainly to combine 2 diff fields into 1 cell and group_concat throws me up an not in library error. And i'm doing this in excel 2007 workbook in VBA.