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.