XlSQL-Y8 - Revision history

Csnyulas: /* Instructions for using the xlSQL-Y8 driver with DataMaster */

2009-03-15T22:13:14Z

‎Instructions for using the xlSQL-Y8 driver with DataMaster

Csnyulas: XlSQL-V8 moved to XlSQL-Y8: Misspelling

2008-06-28T02:18:28Z

XlSQL-V8 moved to XlSQL-Y8: Misspelling

Csnyulas at 02:17, June 28, 2008

2008-06-28T02:17:27Z

Csnyulas at 00:53, June 28, 2008

2008-06-28T00:53:55Z

Csnyulas: 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...

2008-06-27T22:59:35Z

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...

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.net/]. For the list of the enhancements introduced in this new version, please read the [[#New Features|New Features]] section.

Quoting from the original authors of the driver:<BR>
"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 [[Image:XlSQL-Y8.zip | XlSQL-Y8.zip]]

== New Features ==

@@ Line 35: / Line 35: @@
 <code>
      Driver name:   com.nilostep.xlsql.jdbc.xlDriver <BR>
-     JDBC URL:      jdbc:nilostep:excel:[FullPathToTheDirectoryContainingTheExcelFiles]
+     JDBC URL:      jdbc:nilostep:excel:[FullPathToThe'''Directory'''ContainingTheExcelFiles]
 </code>

← Older revision		Revision as of 00:53, June 28, 2008
Line 1:		Line 1:
	= The xlSQL-Y8 JDBC driver for Excel =		= The xlSQL-Y8 JDBC driver for Excel =
		+
		+	<FONT COLOR=RED>This page is under construction. For more information, please revisit it in the future</FONT>

	== Description ==		== Description ==

← Older revision	Revision as of 02:18, June 28, 2008
(No difference)

@@ Line 4: / Line 4: @@
 == Description ==
-The Excel JDBC driver xlSQL-Y8 is an enhancement in many aspect of the xlSQL-Y7 driver downloadable from [https://xlsql.dev.java.net/]. For the list of the enhancements introduced in this new version, please read the [[#New Features|New Features]] section.
+The Excel JDBC driver xlSQL-Y8 is an enhancement in many aspect of the [https://xlsql.dev.java.net/ xlSQL-Y7] driver. This version was created especially to correct bugs and add enhancements to the previous version in order to make the driver correctly work with the [[DataMaster]] Protege plug-in. However, no change made to the driver is DataMaster or Protege specific. For the list of the enhancements introduced in this new version, please read the [[#New Features|New Features]] section.
-Quoting from the original authors of the driver:<BR>
+Here is a short description of this driver qouted from its original authors:<BR>
-"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."
+''"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 [[Image:XlSQL-Y8.zip | XlSQL-Y8.zip]]
+For the moment the only place to download the xlSQL-Y8 driver is the following wiki page: [[Image:XlSQL-Y8.zip | XlSQL-Y8.zip]]
 == New Features ==