(1) Create two user DSNs on two tables of the 2 databases or use the same DSN for two table queries
(2) Specify the table queries in cell B1 and B2
(3) Specify the name of the worksheets. These tables would be automatically filled if compare is ruing in mode 1(see CompareFunctionSetup)
(4) If compare is runnning in mode 2 then manually create two work sheets and fill them with the data to be compared.
Download Excel File(with VBA code) from here :- http://www.4shared.com/document/S61AlXme/DBTableCompareUtil.html
No comments:
Post a Comment