|Hi all, |
I've written a macro which connects to Database and compares almost 500 fields which are present in an XL sheet, with a value in database. I've looped through the cells and compared each value with the field.
for i=2 to numofrows
select * from table1 where field1=cells(i,1);
This approach is taking more time.
Can i use something like this ?
select * from table1 where field1 between (range1 to range2);
pls let me know.. Its very urgent.
Thanks in advance