https://community.blueprism.com/t5/Digital-Exchange/Read-Excel-Data/m-p/59533#M1857 Hi&nbsp;<BR /><BR />I have one million employee records&nbsp; in excel, want to find a phone number of particular employee. What is the best approach?<BR /><BR /><BR /><BR />------------------------------<BR />Sidramappa Hunashyal<BR />SA<BR />Accenture<BR />Asia/Kolkata<BR />------------------------------<BR /> Fri, 28 Feb 2020 16:26:00 GMT sidram.m 2020-02-28T16:26:00Z https://community.blueprism.com/t5/Digital-Exchange/Read-Excel-Data/m-p/59533#M1857 Hi&nbsp;<BR /><BR />I have one million employee records&nbsp; in excel, want to find a phone number of particular employee. What is the best approach?<BR /><BR /><BR /><BR />------------------------------<BR />Sidramappa Hunashyal<BR />SA<BR />Accenture<BR />Asia/Kolkata<BR />------------------------------<BR /> Fri, 28 Feb 2020 16:26:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Read-Excel-Data/m-p/59533#M1857 sidram.m 2020-02-28T16:26:00Z https://community.blueprism.com/t5/Digital-Exchange/Read-Excel-Data/m-p/59534#M1858 Hello Sidramappa,&nbsp;<BR /><BR />You can convert your excel file to an oledb connection and use your excel data as database where you can perform SQL queries agains the data.<BR /><BR />Below is the KB article that explains how to establish this connection:<BR /><BR /><SPAN><A href="http://portal.blueprism.com/customer-support/support-center#/path/1136332732&nbsp;" target="test_blank">http://portal.blueprism.com/customer-support/support-center#/path/1136332732&nbsp;</A><BR /><BR /></SPAN>Let me know if you have any questions.<BR /><BR />------------------------------<BR />Regards, <BR /><BR />David Flores<BR />Sr. Product Consultant<BR />blue prism<BR />------------------------------<BR /> Fri, 28 Feb 2020 22:22:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Read-Excel-Data/m-p/59534#M1858 david.flores 2020-02-28T22:22:00Z