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.
RBS On Thu, Jul 30, 2015 at 7:45 PM, Sylvain Pointeau < sylvain.pointeau at gmail.com> wrote: > On Thu, Jul 30, 2015 at 8:43 PM, Adam Devita <adevita at verifeye.com> wrote: > > > Instead of trying to conform to MS-Excel's csv format, wouldn't it be > > better to write an import from .xls (or .ods if that is an open > > standard) directly? > > > > That way each cell's value can be bound to a position holder in a > > query. No more fussing with "In this country we use this symbol to > > denote decimals", "my data has special characters or line feeds inside > > a cell" etc. > > > > > The level of effort is just not the same, you have to deal with an XML > parser and all. > CSV works also well, I had actually no problem at all handling CSV with H2, > I am just asking the same for sqlite. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
