https://community.blueprism.com/t5/Product-Forum/Error-in-Query-using-OLE-DB/m-p/61375#M14684 That's not a valid query, try removing the asterisk.<BR /><BR />------------------------------<BR />John Carter<BR />Professional Services<BR />Blue Prism<BR />------------------------------<BR /> Mon, 16 Sep 2019 09:01:00 GMT John__Carter 2019-09-16T09:01:00Z https://community.blueprism.com/t5/Product-Forum/Error-in-Query-using-OLE-DB/m-p/61374#M14683 Hello All,<BR />I am using OLE DB connection&nbsp; in BluePrism.<BR />I am trying to execute following Query:<BR /><BR /><STRONG>"SELECT * DISTINCT [User ID ] FROM [Sheet1$]"<BR /><BR /></STRONG>But it is throwing following error message:<BR /><BR />Internal : Could not execute code stage because exception thrown by code stage: Syntax error (missing operator) in query expression '* DISTINCT [User ID ]'.<BR /><BR />Please help me to solve this error.<BR /><BR />Thanks<BR /><BR />------------------------------<BR />Mohini Shelke<BR />RPA Developer<BR />vElement It<BR />------------------------------<BR /> Mon, 16 Sep 2019 05:35:00 GMT https://community.blueprism.com/t5/Product-Forum/Error-in-Query-using-OLE-DB/m-p/61374#M14683 MohiniShelke 2019-09-16T05:35:00Z https://community.blueprism.com/t5/Product-Forum/Error-in-Query-using-OLE-DB/m-p/61375#M14684 That's not a valid query, try removing the asterisk.<BR /><BR />------------------------------<BR />John Carter<BR />Professional Services<BR />Blue Prism<BR />------------------------------<BR /> Mon, 16 Sep 2019 09:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Error-in-Query-using-OLE-DB/m-p/61375#M14684 John__Carter 2019-09-16T09:01:00Z