VBA SQL for all values 1 field
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.
sql = "SELECT PARENT, KIDS FROM DATABASE"
I'm wanting output to be:
Last edited by DaltonMan; March 17th, 2011 at 04:34 PM.