Make A Table with ADODB.Connection

I have an example file attached.
Original file has approx. 20.000 Rows and many names and data.
I want to make a table from records using ADODB.Connection method.
I have tried different ways to get data as for next, for each etc. but theye are very slow and locking the file.
May be, by using ADODB.Connection method this issue could be solved with your value and kind assistance.
You can find detail and explanation at attached file.

Thanks in advance four your help and support.

Regards,
turist.

Why ADO?
Autofilter would be good enough.

Please Login or Register  to view this content.

Dear jindon,
Thanks a lot for your quick reply.
I tried and found result in a very short seconds for 150.000 records.

But, still I wonder how to solve with ADO. If possible I'd like to know with ADO too.

Regards.

ADO

Please Login or Register  to view this content.

ADO on the open workbook causes memory leaks and is best avoided. What's wrong with Jindon's original code?

Great,
Thanks a lot Dear jindon.
Working very good.

Originally Posted by Kyle123

ADO on the open workbook causes memory leaks and is best avoided. What's wrong with Jindon's original code?

There is no wrong with Jindon's code.
I only wanted to learn how to use ADO instead of autofilter.
That's it.