Set listobject as ADODB object and use sql on this.

Hi Guys,

i want to assing existed listobjects to adodb recodsers and use joins of them in Excel.

So "select Current * from table Current left Join Previous On current.order = previous.order"

How to use adodb object n Excel with listobjects?
Have i create always new adodb connection for this?

Best,
Jacek