How to configure JDBC request with MS Excel?

Question

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

nmrao · Answer

Please see this link, hope it is useful to you.
Note that, you can run java code as well from groovy script as well.

http://www.java2s.com/Tutorial/Java/0340__Database/AJDBCProgramtoAccessReadMicrosoftExcel.htm

mani30 · Answer

Hi Rao,&nbsp;Thanks for your reply. I tried the code that you mentioned, but it looks like it is missing the reference to the location where the excel file is to access it.&nbsp;I would appreciate if more information could be provided.&nbsp;Thanks,Mani

nmrao · Answer

Ok, not tried for myself.There, you find another samplehttp://www.java2s.com/Tutorial/Java/0340__Database/UseJDBCODBCbridgetoreadfromExcel.htm

Forum Discussion

How to configure JDBC request with MS Excel?

3 Replies

Related Content

Configure Mockresponse to certain requests

MSTest Configuration

Excel-Write value

Hermes configuration issue

Configuring for and Adding performance counters

Recent Discussions

clone TestSuite fails when there are more project with the same name

Will SOAP UI 5.6.1 work with JDK 8

SOAP Request works in SoapUI, but not in C# code

How to configure Swagger in Paas to use it in Oracle APEX instance.

log4j1.x vulnerability