Hi: To start with I installed sqlite 2.8.17 from Debain Linux lenny. I know about 3.5.9: I'll come to later.
I am tired from using the database Asksam though the Windows emulator wine. At the moment it does not work. I had previously expoted thre Asksam files as text file text-delimited file .txt text-delimited file .csv Iin the latter two cases delimter: space text qualifier: ' Single-line filed All fields Actually there are only a few fields ([ ]) in my files, for 'biology' none, only free text. Now I tried [EMAIL PROTECTED]:~/sqlite$ sqlite biology_text.txt (text file) Unable to open database "biology_text.txt": file is encrypted or is not a database [EMAIL PROTECTED]:~/sqlite$ ls -l total 1448 -rwxrwxrwx 1 francesco francesco 1471942 2008-06-09 08:04 biology_text.txt -rwxrwxrwx 1 francesco francesco 1260 2008-06-09 07:53 biology.txt (text-delimited) [EMAIL PROTECTED]:~/sqlite$ sqlite biology.txt Unable to open database "biology.txt": file is encrypted or is not a database [EMAIL PROTECTED]:~/sqlite$ sqlite biology.csv Unable to open database "biology.csv": file is encrypted or is not a database [EMAIL PROTECTED]:~/sqlite$ sqlite -separator , biology.db ".import biology.csv biologytable" unknown command or invalid arguments: "import". Enter ".help" for help [EMAIL PROTECTED]:~/sqlite$ sqlite -separator , biology.db ".import biology.csv biologytable" I could also export from Asksam as *.html *.html *.rtf or text-delimited *.dat *.prn I understand these are naive questions for sqlite users. Be patient. Thanks francesco pietra -- Dr Francesco Pietra Professor of Chemistry Accademia Lucchese di Scienze, Lettere e Arti, founded in 1594 Palazzo Ducale 55100 Lucca (Italy) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users