i am retrieving data from access using following command
"select * from sheet1 where [question number] like " & list(0) & " and [category] like " & list(1) & "and [sub-category] like " & list(2) & ""
now problem is if list(0)..... contains integer it works but if it is a string containing a,b then it donot work
plz help???

it wont work for string as you missed the single quotes around the parameters.
So it should be like this: [question number] like '" & list(0) & "'

Let me know.. You can read more dev articles on coderewind.com