XlSQL-Y8

From Protege Wiki
Revision as of 15:59, June 27, 2008 by Csnyulas (talk | contribs) (New page: = The xlSQL-Y8 JDBC driver for Excel = == Description == The Excel JDBC driver xlSQL-Y8 is an enhancement in many aspect of the xlSQL-Y7 driver downloadable from [https://xlsql.dev.java.n...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The xlSQL-Y8 JDBC driver for Excel

Description

The Excel JDBC driver xlSQL-Y8 is an enhancement in many aspect of the xlSQL-Y7 driver downloadable from [1]. For the list of the enhancements introduced in this new version, please read the New Features section.

Quoting from the original authors of the driver:
"xlSQL is 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."

Download

For the moment the only place where one can download xlSQL-V8 from, is the Protege wiki, by following this link File:XlSQL-Y8.zip

New Features