On 06/09/2011 08:37 AM, Les Mikesell wrote: > > I'd highly recommend perl for this because it can also do the SQL part > directly via DBI without all of the intermediate contortions you'll have > to do in files otherwise. It should take about half a page of your own > code to connect to the DB, read the file, transform it line-by-line to > sql and execute the sql statements. And unlike other approaches with a > pipeline of different tools, you can generate sensible error messages in > the right places that have something to do with the input. > *AND* by using prepared statements in Perl you don't have to worry about escaping the text to prevent accidental SQL injections. It is all handled for you. -- Benjamin Franz