Comapre Row against ADODb Recordset

[AlexanderBB]

I'm connecting to Access and opening a recordset for data which should match my Worksheet.

Is there a way to check each Excel row against the recordset, without looping through every column?
(They're in the same order on both).

 

[Fazza]

hi,

You could. Just do it like you would compare any two ranges.

Looping would be faster though.

Why do you ask to do it without looping?

regards

 

[AlexanderBB]

Just to get more ideas etc.