Excel AsDB SQL Query

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]”


Hi @km81

Please try this query:

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

Hope this helps,
Best Regards.


Thanks a lot, it works.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.