Hi Friends
Can anyone help me
How to read from an excel sheet in linux?
are there any ODBC drivers for free available
Thanks
How to read from an excel sheet in linux?
Moderators: chulett, rschirm, roy
There are quite a few out there, my google search for "free LINUX Excel ODBC driver" returned over 70,000 pages. I haven't had to use any in production so couldn't recommend any particular one. The easiest way would be to use a .csv format for the Excel sheet - that way it can be processed in Excel and read by the standard text ODBC drivers available for free on all systems.
I just recalled that I read about the OpenOffice ODBC drivers for excel - those would certainly work well.
I just recalled that I read about the OpenOffice ODBC drivers for excel - those would certainly work well.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 9
- Joined: Sun Jun 27, 2010 11:52 pm
DataStage supports ODBC and there are various drivers out there, either one can buy it from IBM, another software vendor, or use free software for LINUX.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>