Python with either xlrd or openpyxl. Why use a multiplicity when one programming environment will do?
> -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Bernardo Sulzbach > Sent: Friday, 31 July, 2015 21:09 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] CSV excel import > > > =CONCATENATE("INSERT INTO myTable VALUES (",a1,","a2");") > > This is so neat. Supposing you are not migrating from a spreadsheet > because it got too big (millions of rows will take a time for this to > finish) and that your data respects a logical grouping, this is very > handy. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
