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-tp28404719p28404719.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
