Hello,
I'm using a cnn = New ADODB.Connection, to get some data from SQL SERVER 2008R2
When I run my simple select statment below, I'm getting thousands of records back. (in the sample attached, I should have received back the first 3 records back only).
if I run the same script inside SQL, I get the proper results. (one record per Tracking).
Any help is appreciated.
Dim cnt As Integer
Dim i As Integer
For i = 2 To Range("A2").End(xlDown).Row + 1
cnt = cnt + 1
It looks like that if your target cell is empty your filter evaluates to '%%' with is no filter at all, explaining the too many records problem. Also, it looks like you're pulling from column A instead of column B .
W.E.B
ASKER
Hello,
This is the way it's supposed to be,
Column "A" is the noteText that I'm looking up in SQL
Results will be in column "B".
The main question I guess is why is it not stopping and ending the macro after the last row used in Column "A"