Do you get a recordset? If so, then

ary = oRS.GetRows()

puts it into an array

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"bwreath " wrote in message
...
Hi,

I would appreciate very much if someone could provide
some examples on how I can capture, manipulate the
data once I have made a connection to a mysql database
from Excel using VBA using ODBC.

I used a macro recorder and I have made a successful
connection to my database but I am not really that familiar
with how to manipulate the data.

Right now I have the data going to the cell A1 in my worksheet.

I am interested in capturing the data into a variable or an array
and then subsequently feeding the result select statement into
another sql statement.
I think it would really help if someone could provide some examples of
data manipulation after the connection.

thanks!


---
Message posted from http://www.ExcelForum.com/