https://community.blueprism.com/t5/Product-Forum/MS-Access/m-p/55054#M9459 Hi all,&nbsp;<BR /><BR />Can I find a way to copy data from MS Access without using SQL statement, our Access file is not able to select data from its table. OR if I can export it to excel that will be good<BR /><BR />------------------------------<BR />aseel odeh<BR />------------------------------<BR /> Mon, 11 Apr 2022 14:57:00 GMT aseelodeh 2022-04-11T14:57:00Z https://community.blueprism.com/t5/Product-Forum/MS-Access/m-p/55054#M9459 Hi all,&nbsp;<BR /><BR />Can I find a way to copy data from MS Access without using SQL statement, our Access file is not able to select data from its table. OR if I can export it to excel that will be good<BR /><BR />------------------------------<BR />aseel odeh<BR />------------------------------<BR /> Mon, 11 Apr 2022 14:57:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Access/m-p/55054#M9459 aseelodeh 2022-04-11T14:57:00Z https://community.blueprism.com/t5/Product-Forum/MS-Access/m-p/55055#M9460 Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/988">@aseelodeh</a><BR /><BR />Is there any business restriction to ​use SQL Statements?<BR /><BR />The only solutions I can think of are:<BR /><BR />- Create an export task to generate an external Excel file, and execute your queries over this file (This link could helps you <A href="https://docs.microsoft.com/en-us/office/vba/api/access.docmd.outputto" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/office/vba/api/access.docmd.outputto</A>)<BR />- Create a "view" over the Access, and use the "Transfer" methods to export the info. (For this, here is a link with more info <A href="https://stackoverflow.com/questions/20496952/programmatically-export-query-table-from-ms-access-to-excel-using-c-sharp" target="_blank" rel="noopener">https://stackoverflow.com/questions/20496952/programmatically-export-query-table-from-ms-access-to-excel-using-c-sharp)</A><BR /><BR /><BR />See you in the community, bye <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />------------------------------<BR />Pablo Sarabia<BR />Architect<BR />Altamira Assets Management<BR />Madrid<BR />------------------------------<BR /> Mon, 11 Apr 2022 16:38:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Access/m-p/55055#M9460 PabloSarabia 2022-04-11T16:38:00Z