xlSQL is a JDBC Driver for Excel, CSV, 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, MySQL, or McKoi SQL dialect. Native xlSQL is a rich subset of SQL for creating, altering, and populating documents.
|Tags||Database Software Development Libraries Java Libraries|
|Operating Systems||OS Independent|
Release Notes: This release featured an "xldba" native DBA interface, the ability to export filesystem data to Excel with dir2xls, and utilities to export Excel to XML or SQL formats (HSQLDB or MySQL). A zero-admin MySQL server that runs out of the Zip file without requiring installation was included.
Release Notes: Y5 is a complete rewrite of version Y4, effectively changing xlSQL into an application framework for developing JDBC drivers for document typed data sources, namely CSV, XML, Word, or any format for which the xlDatabase interface can be implemented.
Release Notes: This is an interim release containing a prototype of the forthcoming CSV JDBC driver. The CSV JDBC Driver is functional for CSV files of the Microsoft format. The CSV JDBC Driver supports the complete SQL dialects of either HSQLDB, MySQL, or McKoi. This release contains a new driver kernel for both Excel (not included) and CSV.
Release Notes: This is the first public alpha release.