2. PHPRunner General questions
  3. how to connect excel sheet as database
This topic is locked

how to connect excel sheet as database

 		8/26/2020 4:36:34 AM
PHPRunner General questions
A
 admin author

Hi
How we can connect the Excelsheet as database. I am trying to connect but its asking ODBC driver and ODBC list are not having .xlsx driver. is there any specific driver to connect excel.
Thanks & regards

Sami
aadham 8/26/2020



Hi
How we can connect the Excelsheet as database. I am trying to connect but its asking ODBC driver and ODBC list are not having .xlsx driver. is there any specific driver to connect excel.
Thanks & regards

Sami


Download/install the Microsoft Access Database Engine 2010.
Sergey Kornilov admin 8/26/2020

While it is possible to connect to Excel file when you have the proper ODBC driver installed we highly recommend against doing so. Excel is not a real database and attempts to use it as one will produce nothing but pain.