Hi, Thaks for the help, and the links Here are the 2 first lines of the cvs file:
Costa de Xurius,T.SLP,42.5,1.48333,AD,,,0,,Europe/Andorra,1.0,2.0,1.0 Font de la Xona,H.SPNG,42.55003,1.44986,AD,Parroquia de la Massana,,0,,Europe/Andorra,1.0,2.0,1.0 I've used mode, and import. But I've got the error: "failed:duplicate column name" Regards, Miguel Fernandes On Fri, Jul 18, 2014 at 3:44 PM, Richard Hipp <[email protected]> wrote: > On Fri, Jul 18, 2014 at 10:23 AM, Rui Fernandes <[email protected]> > wrote: > > > Greetings from Portugal, > > > > 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? > > > > Yes, SQLite always assumes "." is your decimal point. If you have data > using "," as the decimal point, you'll have to convert it first. > > Instructions for doing CVS import on SQLite are at > http://www.sqlite.org/cli.html#csv > > > > > > > Another question is the password: is it possible to place a password to > > protect the database? > > > > There is a (non-free) extension for that: > http://www.hwaci.com/sw/sqlite/see.html > > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
