Mani30
10 years agoNew Contributor
How to configure JDBC request with MS Excel?
How can we configure JDBC Request with MS Excel in Soap UI (Open source)?
What would be the Driver and Connection string to be used while configuring? Also what changes in Microsoft Excel should we do for it to work?
I tried using the below mentoined connection driver and connection string and the connection test passed. But when I execute my query, I get an error.
Driver: sun.jdbc.odbc.JdbcOdbcDriver
Connection String: jdbc:odbc:driver={Microsoft Excel Driver (*.xls)};DBQ=D:\\ExcelDatabase.xls
Answers are appreciated.
Thanks,
Mani