How to assign query results to cells

T

Tangier

mysql01 = " SELECT "
mysql02 = " ChildRecords.ChildID "
mysql03 = " FROM ChildRecords "



ActiveWorkbook.Worksheets.Add
With ActiveSheet.QueryTables.Add(Connection:= _
"ODBC;DRIVER={Microsoft Access Driver (*.mdb)};Dbq=SomePlace"
_
, Destination:=Range("A1"))
.CommandText = Array(mysql01, mysql02, mysql03)

How do I assign the results, ChildRecords.Child to a specific cell?
 
Top