Reading excel file in Unix through ODBC driver

Hi,

I have a program in Java running in Windows for reading Excel file.I have created a DSN for the excel file in ODBC datasources and read the contents of the file like reading from a database table using JDBC. I want to port this code in Unix environment. Is there any Odbc driver for Excel in Unix? Any inputs on how to port this into UNix environment is gretaly appreciated.Please reply me back if anyone has a solution and it is very urgent.

THanks a lot for help
Chithra

What kind of database?

Generally speaking, you need to export the excel file as a csv file, you can then either load that file directly by logging into your database server and running something like:

Or you can parse the file through some script and load it however you need to.

Note, the query above is generalized and will probably be different for whatever database engine you're using (MySQL, Postgres, Oracle).

Hi,

Thanks for the suggestion. But I have a constraint of maintaining the excel file in.xls format itself and not convert to csv format.That's the reason I am looking for replicating the same scenario as in Windows(Like creating dsn with odbc and then trying to read).Loading the same into database is not a problem.Is it possible to read the data from excel file itself in Unix without coverting it into csv format?

Thanks in advance

http://www.excelparser.com/index.php
This one reads xls files under Linux for 80 bucks.

While this one appears to do it for free, though requires some hand-holding. YMMV.
http://cran.r-project.org/src/contrib/D ... gmisc.html