Migrate Excel (MS Access) to Rails

Rails
1

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.

2

John S. 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

3

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

–
Ryan B.

Feel free to add me to MSN and/or GTalk as this email.

4

On 04/01/2008, John S. [email protected] 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.

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:
NameBright - Coming Soon

-Thomas

–
Thomas P.
[email protected]
[email protected]
Büro: 030 - 830 353 88
mobil: 0176 - 75 03 03 04
Privat: 030 - 49 78 37 06