It's the header, right? Must contain the fields names. Am I right?
Kind regards, Miguel Fernandes On Fri, Jul 18, 2014 at 4:15 PM, Rui Fernandes <[email protected]> wrote: > 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
