No I had not used ".mode" - the wording described ".mode" as "set output mode where." . the word "output" made me think this was for .output statement.
I just tried " .mode csv ". what do your * mean? Do I put in the file and/or table name or nothing more? I tried several different ways but still get same error when I try to import. Without knowing syntax, I'm forced to ask these dumb questions or give up (not) . since no good documentation - sorry. Thanks, Have you ran *.mode csv*? Jonas Malaco Filho 2012/5/7 peter korinis <korinis at earthlink.net> > Regarding SQLITE3.exe statement ".import FILE TABLE" > I created a table. > My input file is a comma-delimited text file > When I run .import I get the following "Error: FILE line 1: expected 46 > columns of data but found 1" > It seems .import is not recognizing comma delimiter. > I suspect this is a simple syntax error, but I don't find any > document/explanation. pk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users