>---------- Forwarded message ---------- >From: "maksood alam" <786maksood at 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;'"
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
