cancel
Showing results for 
Search instead for 
Did you mean: 

How to configure JDBC request with MS Excel?

Mani30
New 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

3 REPLIES 3
nmrao
Community Hero

Re: How to configure JDBC request with MS Excel?

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


Regards,
Rao.
Mani30
New Contributor

Re: How to configure JDBC request with MS Excel?

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

nmrao
Community Hero

Re: How to configure JDBC request with MS Excel?

Ok, not tried for myself.

There, you find another sample
http://www.java2s.com/Tutorial/Java/0340__Database/UseJDBCODBCbridgetoreadfromExcel.htm


Regards,
Rao.
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors