Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|