Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Recordsets
If I run a query to create a recordset....and then copy it to Excel....and
then later on that day, I run the SAME query..but this 2nd recordset, based on the same query as the first, has been updated with new items. What is the easiest way to just compare this new recordset with the old one (or either compare the two resulted recordsets once they have been copied to excel). What I want to do is extract the updated items from recordset 2 and add them to the results of recordset 1...would like to do in code. Currentl;y, I copy both to excel and use array formulas to compare the 2...it takes far too loong..... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Recordsets
Hi,
check out this link and you might need to modify the code in-between http://www.exceltip.com/show_tip/Cel...Excel/476.html regards Kamal "ibeetb" wrote in message ... If I run a query to create a recordset....and then copy it to Excel....and then later on that day, I run the SAME query..but this 2nd recordset, based on the same query as the first, has been updated with new items. What is the easiest way to just compare this new recordset with the old one (or either compare the two resulted recordsets once they have been copied to excel). What I want to do is extract the updated items from recordset 2 and add them to the results of recordset 1...would like to do in code. Currentl;y, I copy both to excel and use array formulas to compare the 2...it takes far too loong..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem displaying recordsets in Excel Format | Excel Discussion (Misc queries) |