CODEWITHSUNDEEP
sqlexcelexcel-2007connection-stringvba
Sr7
Sr7

Reputation: 341

VBA: Query With Excel Tables as the Datasource

I want to query the table, which consists of a named range, from VBA using SQL.

name id
Alpha 1
Beta 2
Gamma 3

I want to perform a query like, select Name from table1 where id =3 in VBA

Can someone help with the connection string that needs to be used?

Upvotes: 1

Views: 3047

Answers (1)

SteveCav
SteveCav

Reputation: 6729

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

Upvotes: 2

Related Questions