IF or CASE in SQL on Excel Sheet

[carsto]

Using VBA in
Excel 2016 64 bit
with
Microsoft.ACE.OLEDB.12.0

Can query 97-2003 Excel File (.xls)
successfully with simple

Please Login or Register  to view this content.

But I need to add

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[Norie]

Does this work?

Iif(Field3 = 'A' Or Field3 = 'B', 'RED', 'BLUE') AS 'COLUMNNAME

[carsto]

It does, thank you. I thought IFF only worked on Access.

Do you know of a source for comprehensive information of Excel SQL syntax? I can't find one.3

[Norie]

I don't think there is such a thing, as far as I'm aware when querying an Excel file you would use 'standard' SQL.

You can however use some VBA functions, e.g. Iif.