I don't know what happened to my links in the previous email. ?Again: http://www.gdal.org/ogr_sql_sqlite.html http://www.gdal.org/drv_sqlite.html ?
On Monday, May 11, 2015 12:01 PM, Peter Aronson <pbaronson at att.net> wrote: It's a little indirect, but starting with GDAL 1.10, if you have a version oft he GDAL dynamic library built with both SQLite support and XLS and/or XLSX support (depending on which you need), you can load the GDAL library as a SQLite extension using the load_extension SQL function, and then create a virtual table of an Excel spread-sheet using the VirtualOGR module (see http://www.gdal.org/drv_sqlite.html?and?http://www.gdal.org/ogr_sql_sqlite.html). ?There might be a simpler approach, of course. Peter? ? ? On Monday, May 11, 2015 11:08 AM, maksood alam <786maksood at gmail.com> wrote: ? ---------- Forwarded message ---------- From: "maksood alam" <786maks...@gmail.com> Date: May 11, 2015 11:21 AM Subject: bulk upload from Excel To: <sqlite-users at sqlite.org> Cc: Hi Team, Do we have any option like below for the bulk upload. INSERT INTO tbl_test1 SELECT * FROM [asd$] IN '" & ThisWorkbook.FullName & "' 'Excel 8.0;'" _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ? _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users