Query Sheet using a WHERE clause?

  • Thread starter Thread starter Icemak
  • Start date Start date
I

Icemak

Using ADO I can:

SELECT * from [Sheet1$A1:B50]

and get the lot... but I just what the row that has A$="Blah" and

SELECT * FROM [Sheet1$A1:B50] WHERE A$='Blah'

does not work.. and was wondering if anyone here has come across thi
before and might have a solution?

Thank
 
Back
Top