[sqlite] Fwd: bulk upload from Excel

-- Forwarded message -- From: "maksood alam" <786maks...@gmail.com> Date: May 11, 2015 11:21 AM Subject: bulk upload from Excel To: Cc: Hi Team, Do we have any option like below for the bulk upload. INSERT INTO tbl_test1 SELECT * FROM [asd$] IN '" & ThisWorkbook.FullName & "'

[sqlite] Fwd: bulk upload from Excel

>-- Forwarded message -- >From: "maksood alam" <786maksood at gmail.com> >Date: May 11, 2015 11:21 AM >Subject: bulk upload from Excel >To: >Cc: > >Hi Team, > >Do we have any option like below for the bulk upload. > >INSERT INTO tbl_test1 SELECT * FROM [asd$] IN '" &

[sqlite] Fwd: bulk upload from Excel

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 wrote: It's a little indirect, but starting with GDAL 1.10, if you have a version oft he

[sqlite] Fwd: bulk upload from Excel

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