Id like to import a csv, comma delimited file, into a table (sqlite3 db) in my Ruby application. I can do it either of three ways:
1.) With a SQL statement like the COPY command. Ive read this was taken out, but then found a place that said it has been reimplemented? Ive had no luck with anything Ive tried this route. 2.) I can execute a system command through code: $> sqlite3 < myfile Obviously that isnt the right syntax, but Im looking for the correct syntax to import a csv into a specifc table from the command line like that. 3.) I dont see how it would be possible to use the .import functionality through code? If its possible please enlighten me. Any helpful suggestions would be very much appreciated! Joe Noon
