xlSQL - JDBC driver for XLS and CSV

xlSQL - JDBC driver for XLS and CSV


xlSQL - JDBC driver for XLS and CSV
https://xlsql.dev.java.net/
 
a JDBC Driver for Excel ( CSV, XML and other ) document data sources. Documents can be read and written with SQL as if they were tables in a database. In the case of Excel, xlSQL maps a directory with Excel files to a database, workbooks to schemas, and sheets to tables. These tables can be queried with the full SELECT syntax of either the HSQLDB or MySQL (more to follow) SQL dialect. Native xlSQL is a rich subset of SQL for creating, altering and populating documents ( spreadsheets ). The xlSQL Yn codebase, although alpha, has been taken into production at numerous sites worldwide. xlSQL has proven to be a very stable read-write SQL Excel JDBC Driver. Continuous development efforts are aimed to explore the limits of the XLS fileformat for storing relational data and to support other document formats as CSV and XML.

Tags: io

File Formats: CSV XLS XML