VBA SQL Query not returning All Results

When running query SELECT * FROM [Input$A1:G57] Where [info2] = "Aasvoelnes_U9A_0" OR [info2] = "Affenberg_U9A_1" ORDER BY [info2] in attached xlsb book, it is only returning the first 14 results although it is suppose to be 57 results.

Here is the code:

Please Login or Register  to view this content.

There are only 14 records that have those values in the info2 field. The code is working correctly, wha are you actually trying to do?

P.S Running ADO on an open workbook isn't a good idea, it causes memory leaks

My apologies , yes I was focused on the Name Field & not the Info Field

So one should rather use oledb connection?

Thank you Kyle123

No, you should use advanced filter

Just saw your other post on https://www.excelforum.com/excel-pro...db-12-0-a.html

Maybe I can try Power Query in Excel although it seems it uses different syntax than normal SQL.

Advanced Filter is Excel - why can't you use that? I'd be surprised if ADO is actually faster

Hi Kyle123, I have started playing with Advanced Filters & it is way better then the normal filter and learned to copy & paste only specific columns very much like SQL, so I will be using them from now one, thank you I learned something very helpful today