hi this query doesnot work
a and b are both numbers
a b
1 1
2 2
3
4
str1 = "select b from [sheet1$] where b not in (Select a FROM [Sheet1$])"
hi this query doesnot work
a and b are both numbers
a b
1 1
2 2
3
4
str1 = "select b from [sheet1$] where b not in (Select a FROM [Sheet1$])"
Where exactly are you trying to write this query?