Migrate Excel (MS Access) to Rails

Is there any form to migrate an Excel table(which becomes from Access)to
Rails? I have the models with scaffolds, but I would like to have all
the data with only a migration.

John Smith wrote:

Is there any form to migrate an Excel table(which becomes from Access)to
Rails? I have the models with scaffolds, but I would like to have all
the data with only a migration.

i don't know about any 'direct' way to do that. but it should be rather
easy to export csv and write a small controller/action in rails to
import it. maybe you can even do something from script/console

If you’re using CSV to import the date I recommend using fastercsv: https://rubyforge.org/projects/fastercsv/

you could export the spreadsheet data with my gem ‘roo’ (
http://roo.rubyforge.org/) and then load these yaml files into your database as it is described here:
http://www.urbanpuddle.com/articles/2007/10/19/load-fixed-data-into-your-rails-app

-Thomas