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 ...
Forum Discussion
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
Note that, you can run java code as well from groovy script as well.
http://www.java2s.com/Tutorial/Java/0340__Database/AJDBCProgramtoAccessReadMicrosoftExcel.htm
Hi Rao,
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.
I would appreciate if more information could be provided.
Thanks,
Mani
- Ok, not tried for myself.
There, you find another sample
http://www.java2s.com/Tutorial/Java/0340__Database/UseJDBCODBCbridgetoreadfromExcel.htm
