[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 & "' 'Excel 8.0;'"
[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 '" & >ThisWorkbook.FullName & "' 'Excel 8.0;'" You could use AutoIt (freeware) which offers support for both Excel and SQLite. This is a basic-type Windows scripting language with a load of features to ease automation up to create real-world applications. JcD
[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 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: 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
[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 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: 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