IN Operator in OLEDB

Santiago Redondo 1

I'm working with Excel and i cant get this to work:

SELECT * FROM [A] WHERE [Article_Name] IN ('A','B')

I dont know how to write it to make it work

This works for example: SELECT * FROM [A] WHERE ([Article_Name] = 'A') OR ([Article_Name] = 'B')

But i want to use the IN operator

Any help will be appreciated it, thanks!

Viorel 125.7K Reputation points

2022-08-23T03:00:08.55+00:00

Are you accessing an SQL Server database from Excel VBA?
ZoeHui-MSFT 41,536 Reputation points

2022-08-23T05:50:46.977+00:00
Hi @Santiago Redondo ,

I used below code and it works fine from my side, please have a double check.

SELECT * FROM [Sheet1$] WHERE [Name] IN ('A','B')

If I misunderstand your issue, please incorrect me.
Santiago Redondo 1 Reputation point

2022-08-23T17:50:47.213+00:00

I tried again today but still couldnt manage to make it work

This is what i get when trying to use IN
(its in spanish my excel but that doesnt changes anything)

Your answer