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
