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???

Re: Data retrieving using ms-access 80 80

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.