Excel AsDB SQL Query

[km81 (Km)]

I need to read an excel with sheet name Base EBR+Manual and filter Country as CA
i tried with below query but it throws error pls help on this

“SELECT * FROM [Base EBR+Manual$ ] WHERE [Country=CA]”

Thanks

[arjunshenoy]

Hi @km81

Please try this query:

"SELECT * FROM [Base EBR+Manual$] WHERE [Country] = 'CA'"

Hope this helps,
Best Regards.

[km81 (Km)]

@arjunshenoy

Thanks a lot, it works.