Error in Query using OLE DB

[MohiniShelke]

Hello All,
I am using OLE DB connection  in BluePrism.
I am trying to execute following Query:

"SELECT * DISTINCT [User ID ] FROM [Sheet1$]"

But it is throwing following error message:

Internal : Could not execute code stage because exception thrown by code stage: Syntax error (missing operator) in query expression '* DISTINCT [User ID ]'.

Please help me to solve this error.

Thanks

------------------------------
Mohini Shelke
RPA Developer
vElement It
------------------------------

[John__Carter]

That's not a valid query, try removing the asterisk.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------