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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Placing query results in a cell 1
Connectnig My Access Database (2002) to Excel 2002 1
Connecting My Access Database to Excel 1
Variables in Query Strings 1
General ODBC error AS400 3
Refresh Excel Sheet with Access Data Frequently 0
SQL ODBC Connection 1
VBA: how to get variables into querry code 2

Top