SQL <SELECT> with condition

[brucelim80]

hi
Can anyone help me with this problem? i am a newbie for VBA
programming.


My excel cell look like this
A B
1 user description
2 83 london
3 84 usa
4 45 italy
5 84 Rome

The sheetname is called data


How do i write an SQL statement to Extract the description where the
user is 84

SELECT * FROM [data$] Where user='83'

I have an error when executing with ADODB.Recordset: " Data type
mismatch in Criteria Expression"
Runtime error ' -2147217913 (80040e07)'

Thank you

 

[DM Unseen]

Could be SELECT * FROM [data$] Where user=83 because the database
driver sees the user column as a column of type number.

You could use MSQuery to create Excel SQL queries based on Excel
workbooks, no need to actually code this.

DM Unseen