On 2014/07/18 16:23, Rui Fernandes wrote:
Greetings from Portugal,
Olá Rui,
I made my firt import of a cvs file to the SQLite, and save it as a file. My newbie question is that Sqlite is assuming every line as a record of text, not separating the fields.... Must the text fiels be surrounded by "? And it will assume the . as decimal point?
Do you mean .csv file? Is it in the format prescribed by the CSV standard rfc? If so, quoting is only needed for problem values (which include quotes or separators).
Maybe simply post the first 2 lines or so here, we will be able to tell.
Another question is the password: is it possible to place a password to protect the database?
Sorry no, SQLite is file-based access DB, anyone who has access to the file will have access to the DB - unless you use an encryption extension such as SEE - which is commercially available from:
http://www.hwaci.com/sw/sqlite/see.html adeus! _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
