You're seeing on of my pet peeves...error messages like "cannot open file" or Microsoft's famous "cannot load dll". Some of us need to know WHY.
So, change all your "cannot open" lines in shell.c to this: fprintf(stderr, "Error: cannot open \"%s\":%s\n", zFile, strerror(errno)); Then you'll see the real errror which could be permissions, not found, or some other. And if it says "No such file..." then maybe you have some funky character. Can you "more" the filename? Then show us your complete line of execution like this: vi test.txt (insert line '1') ./sqlite3 test.db create table test2(code integer); .import 'test.txt' test2 And the resultant error message. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Helen Chen [xche...@partners.org] Sent: Monday, December 05, 2011 12:41 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] import data error message cannot open file Dear all, I am using Mac OX to run sqlite 3. In sqlite 3 I typed in create table test2(code integer); Then I typed .import 'cheps.txt' test 2 It then give me error message saying that cannot open "cheps.txt" I also tried without the '' around the file name. The database, the text file and sqlite.ext are in the same path. Can any one tell me why this is the case? Thank you very much. Helen The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Partners Compliance HelpLine at http://www.partners.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users