On Fri, Jul 18, 2014 at 11:15 AM, 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" > Please see http://www.sqlite.org/mark/cli.html?In+the+first*table.#csv > > 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 > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
