HXTT Excel contains the only type 4 JDBC(1.2, 2.0, 3.0, 4.0, 4.1) driver packages for Microsoft Excel version from 95, 97, 98, 2000, 2001, XP, 2002, 2003, 2004, 2007, to 2010, which supports transaction, embedded access, remote access, client/server mode, memory-only database, compressed database (.ZIP, .JAR, .GZ, .TAR, .BZ2, .TGZ, .TAR.GZ, and .TAR.BZ2), SAMBA database(SMB), URL database(http, https, and ftp). Through the embedded Pure Java database engine, MS Excel database can be deployed and accessed on any platform with JVM. With JDBC1.2, JDBC2.0, JDBC3.0, JDBC4.0, jdbc4.1, and SQL92 support, programmers needn't special coding, and DBA can use any Java database tool to access easily local data or remote data.
Limitations:
50-queries,100-rows per query
Comments not found