Excel / VBA / SQL DB
 

Anybody done any work with Excel / VBA / SQL DB?

Can you give me some pointers on how I could do the following all in one VBA
routine:

1) From a cell variable value (ie, user enters a customer code), I query
table A and put the data into a worksheet starting from say cell A1.

2) A blank row is created after the last data line in point 1 above.

3) Using the same cell variable, query table B and put the data into the
worksheet starting from the row after the blank row in point 2 above.

and so on.

Like I've said before I work with ASP all day and know about ADO
connections, commands and recordsets, so is it something similar to this??

Man thanks.

Rgds

Laphan

Excel / VBA / SQL DB
 

Please see response to earlier thread.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Laphan wrote:
Anybody done any work with Excel / VBA / SQL DB?

Can you give me some pointers on how I could do the following all in
one VBA routine:

1) From a cell variable value (ie, user enters a customer code), I
query table A and put the data into a worksheet starting from say
cell A1.

2) A blank row is created after the last data line in point 1 above.

3) Using the same cell variable, query table B and put the data into
the worksheet starting from the row after the blank row in point 2
above.

and so on.

Like I've said before I work with ASP all day and know about ADO
connections, commands and recordsets, so is it something similar to
this??

Man thanks.

Rgds

Laphan