Read Excel Data

[SidramappaHunas]

Hi 

I have one million employee records  in excel, want to find a phone number of particular employee. What is the best approach?



------------------------------
Sidramappa Hunashyal
SA
Accenture
Asia/Kolkata
------------------------------

[david.flores]

Hello Sidramappa, 

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.

Below is the KB article that explains how to establish this connection:

http://portal.blueprism.com/customer-support/support-center#/path/1136332732 

Let me know if you have any questions.

------------------------------
Regards,

David Flores
Sr. Product Consultant
blue prism
------------------------------