Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to output recordset data to sheet
Hi,
I am writing a macro which uses ADO to connect to DB2 AS/400 database and return the recordset data to the worksheet. But I found that when I use ADO with QueryTable, there is some problem such as only part of data is returned to the worksheet,..etc. Therefore, rather that using QueryTable, is there any other method with can return recordset data field by field into seperate worksheet columns? Thanks a lot. Terence |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help getting output value from another sheet | Excel Discussion (Misc queries) | |||
query a recordset | Excel Discussion (Misc queries) | |||
Recordset.FindFirst argument not working... | Excel Worksheet Functions | |||
return recordset | Excel Discussion (Misc queries) | |||
Default recordset type? | Excel Programming |