Hi @Nakkireddyvari Tharaka Prabhu
Step 1:
Download the Access Database Engine on Microsoft Portal
Link: https://www.microsoft.com/en-in/download/details.aspx?id=13255
Click on Download
Select AccessDatabaseEngine.exe to download and get it installed
Step 2:
Database: Connect
Select connection mode as default and in the connection string using the below string to make your excel to connect with the database engine
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="ExcelPath";Extended Properties="Excel 12.0 Xml;HDR=YES"
Step 3:
Example Query how to use SELECT statement:
SELECT *FROM *SheetName$$] WHERE ColumnName = "Condition" and ColumnName = "Condition";
Hope I have answered your query, if yes Mark my answer as "Best" 🙂
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.