On Tue, Sep 22, 2009 at 3:04 PM, Simon Slavin <slav...@hearsay.demon.co.uk> wrote: > > On 22 Sep 2009, at 10:49pm, Simon Davies wrote: > > If you're going to need to import such files frequently, you might > need to write some code to do the import properly.
Hey there, Its not necessarily difficult to use a scripting language, such as Perl, Ruby, or Python, to parse the CSV file and write to your database. For example, Ruby has a "gem" called fastercsv. Such a script would have around 10 lines of code. Would also be more robust in the long run. See you, Stephan > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http://www.thrackle.org -> http://www.buckmaster.ca -> http://www.trafficlife.com -> http://stephansmap.org -- http://blog.stephansmap.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users