Just a guess, but you may be running into issues with the end-of-line character as they are different under linux (\n), Mac (\r), and Windows/DOS (\r\n).
Linux has a tool to convert Windows/DOS end-of-lines to linux-style called dos2unix. There may be one for Mac, too, but I'm not sure. If not, you could use tr. For example: $ < mac.csv tr '\r' '\n' > unix.csv Good luck and let us know how things go. Regards, - Robert On Tue, Sep 8, 2009 at 1:47 PM, Kavita Raghunathan<kavita.raghunat...@skyfiber.com> wrote: > Yes, this works. Must have been my original csv file. > I was using mac based excel and I'll now try using the windows based excel. > Thanks to all for the awesome support. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
