Query Excel data

[AlexanderBB]

I understand Excel can't open a connection to itself, and create an sql-based Recordset without memory leaks.
Has this been fixed in later versions, or does the problem remain?

In which case are there other solutions?

My goal is to output my query (or equivalent) to a Listview control. Can I 'bind' the control to the data or must I iterate through every entry?
Maybe someone has done something similar, I'm at the design stage and would I'd appreciate any pointers.

Thanks.