Never considered that option but I think it will be a lot slower.
Currently I work with these 2:
https://sqliteforexcel.codeplex.com/
http://www.vbrichclient.com/#/en/About/
RBS
On Fri, Jul 31, 2015 at 1:47 AM, Simon Slavin <slavins at bigfraud.org> wrote:
>
> 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.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
