Excel tables as the datasource in VBA

Question

I want to query the table (Named range) from vba using SQL.

name id
Alpha 1
Beta 2
Gamma 3

I want to query like, "select Name from table1 where id =3" in VBA can someone help with the connection string that needs to be used.

thanks! Srin

Answer 1

This puts it pretty well: http://vbadud.blogspot.com/2007/12/query-table-with-excel-as-data-source.html