# Migrate Excel (MS Access) to Rails

**URL:** <https://www.ruby-forum.com/t/migrate-excel-ms-access-to-rails/125001>\
**Category:** Rails\
**Created:** [January 4, 2008, 2:19pm UTC](https://www.ruby-forum.com/t/migrate-excel-ms-access-to-rails/125001 "2008-01-04T14:19:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![captaffy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/f04885/32.png) [@captaffy](https://www.ruby-forum.com/u/captaffy)\
**Post date:** [January 4, 2008, 2:19pm UTC](https://www.ruby-forum.com/t/migrate-excel-ms-access-to-rails/125001/1 "2008-01-04T14:19:10Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![captaffy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/f04885/32.png) [@captaffy](https://www.ruby-forum.com/u/captaffy)\
**Post date:** [January 4, 2008, 3:42pm UTC](https://www.ruby-forum.com/t/migrate-excel-ms-access-to-rails/125001/2 "2008-01-04T15:42:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![captaffy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/f04885/32.png) [@captaffy](https://www.ruby-forum.com/u/captaffy)\
**Post date:** [January 7, 2008, 2:49am UTC](https://www.ruby-forum.com/t/migrate-excel-ms-access-to-rails/125001/3 "2008-01-07T02:49:00Z")

</div>

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

–  
Ryan B.

> **[frozenplague.net](http://www.frozenplague.net)**
>
> This domain may be for sale!

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

---

<div class="post-metadata">

**Author:** ![captaffy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/f04885/32.png) [@captaffy](https://www.ruby-forum.com/u/captaffy)\
**Post date:** [January 7, 2008, 10:49am UTC](https://www.ruby-forum.com/t/migrate-excel-ms-access-to-rails/125001/4 "2008-01-07T10:49:47Z")

</div>

On 04/01/2008, John S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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/](http://roo.rubyforge.org/)) and then load these yaml files into your  
database  
as it is described here:  
[NameBright - Coming Soon](http://www.urbanpuddle.com/articles/2007/10/19/load-fixed-data-into-your-rails-app)

-Thomas

–  
Thomas P.  
removed\_email\_address@domain.invalid  
removed\_email\_address@domain.invalid  
Büro: 030 - 830 353 88  
mobil: 0176 - 75 03 03 04  
Privat: 030 - 49 78 37 06

> **[thopre](https://thopre.wordpress.com/)**
>
> Entwicklungen für die Bühne des Lebens

> **[ThoPre.com is for sale | HugeDomains](https://www.hugedomains.com/domain_profile.cfm?d=thopre.com)**
>
> The leading source brandable domain names. Competitive prices. Excellent service. Get your domain name today.