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
