[sqlite] import data error message cannot open file

2011-12-06 Thread Helen Chen
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,

Re: [sqlite] import data error message cannot open file

2011-12-06 Thread Black, Michael (IS)
...@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

Re: [sqlite] import data error message cannot open file

2011-12-06 Thread Simon Slavin
On 5 Dec 2011, at 6:41pm, Helen Chen wrote: I am using Mac OX to run sqlite 3. In sqlite 3 I typed in create table test2(code integer); You hit return key ? You got a prompt back ? Then I typed .import 'cheps.txt' test 2 You should have typed .import cheps.txt test2