Import from excel, data store in database


#1

Hi,
Im tryng to import data from excel sheet and storing data into
database.

But geeting problem.
I hv followed this link : http://spreadsheet.rubyforge.org/

Error occurs

" OLE2 signature is invalid"

If any one having solution then plz let me know.


#2

This is just a shot in the dark. Are you trying to import from Excel
2007 (.xlsx)? I’ve had problems with other applications reading that
format. I resolved it by saving the file as Excel 2003 (.xls) and it
worked.