On 31 Jul 2015, at 1:32am, Bart Smissaert <bart.smissaert at gmail.com> wrote:
> Moving data from Excel directly to SQLite seems the best option to me as
> all the values are clearly separated.
> No need for XML. An Excel sheet range can be directly converted to a
> variant array and from there it is simple and
> fast to move the data to SQLite. I have written an Excel add-in that does
> this.
Had you considered using Excel to write SQL commands ? You can use Excel
functions like
=CONCATENATE("INSERT INTO myTable VALUES (",a1,","a2");")
which will give you a column of SQL commands. You can then select and copy
this column of commands and paste them into the SQL shell tool.
(Above is simplified and you may need to get more complicated to paste your
values.)
Simon.
