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 o
data manipulation after the connection.

thanks

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