I have to create Excel Sheets using Visual Basic 6 based on two Excel files given. I have to compare 2 columns in the given Excel files, that is the col B in Excel 1 with Col G in Excel 2-
The Excel files are quite large I am using ADODB and getting the data from the first Excel file.
I am using 2 connections to acquire data from both the files but am unable to use the where clause in the cmd statemnet ie
cmd = select * from excel2 where excel2.col2='abc'
Is my approach efficient?
How do I define the column excel2.col2 to execute this statemnet?