![]() I want it to not treat it as a data row, but use it to determine which column the data should be added to. import c: /users/inspiron/desktop/people2012.csv people2012 The result of which is: c: /users/inspiron/desktop/pessoas2012.csv:11: expected 120 columns but found 1 - filling the rest with NULL However, when specifying the base, there is no value in the columns. import table1.csv table1 SQLite3 will just treat the column names as a data row. Last updated: JanuSQLite CSV FAQ: How do I import a CSV file into a SQLite database table If you’re not using an autoincrement (primary key) field in your database table, importing CSV file data into a SQLite database is straightforward, though you may have to do some work to clean up your data first. ![]() I have a situation where I have CSV files with column names in the first row, which perfectly match the tables in my SQLite3 db, except they are in a different order. I get a dialog with the following fields, Table Name filled in with the table name taken from the csv file, Column names in first line - checked, Field separator - comma, Quote character - double quotes, Encoding - UTF-8, and Trim fields - checked. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |