I tested using a blank space between the commas, like this (", ,") instead of
this (",,") and this way the value of the next column is not put in the null
column. But then the column is a blank space instead of a null.am65 wrote: > > I'm using the Mozilla add-on SQLite Manager 0.5.14 (SQLite 3.6.16). > > I'm trying to import a CSV file into a SQLite table but the blank columns > in the file (two commas with nothing inside) are not imported. For example > if the file is like that: > > Col A, Col B, Col C > textA,,textC > > is imported into the table like this: > > Col A Col B Col C > textA textC > > What is strange is that it used to do the import correctly. But from a > certain point of time it started to ignore the blank columns. > -- View this message in context: http://old.nabble.com/cannot-import-blank-columns-in-a-Sqlite-table-tp28404719p28409253.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
