i got problem to load data from file to database. is it because my sql command? --- def uploadarc @results = $m.query("LOAD DATA LOCAL INFILE ''C:/InstantRails/rails_apps/cron/sample.txt'' INTO TABLE archives FIELDS TERMINATED BY ''\n'' ENCLOSED BY ''\"'' LINES TERMINATED BY ''\n\n''") flash[:notice]=" Uploaded " redirect_to :controller => ''test'', :action => ''index'' -- Posted via http://www.ruby-forum.com/.