Run SQL on excel
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
Menu
▾
▴
#604 Run SQL on excel
Good day,
My goal is to execute SQL queries on an excel sheet (.xlsx) using Squirrel. However, I have difficulties to find a suitable driver. I have already tried to include the following driver but without success: https://github.com/monitorjbl/excel-streaming-reader
It fails on the one hand because there is no main method as entry point, additionally I have no information about the jdbc url.
Has anyone ever had a similar project or can help me with mine. For a hint where I can find a suitable driver, I would also be very grateful.
I'm afraid Excel Streaming Reader is not a JDBC driver and cannot be used with SQuirreL.
You may want to look at http://www.hxtt.com/excel.html unfortunately not free.