read data from ms-access or excel-file on linux plattform
843854Apr 8 2004 — edited May 7 2004Hi everybody!
I have a problem. I'm going to transfer an application from windows-2000 server to a linux-server. This application is written in pure java using java-servlets. one of the features of this application is, that it is possible to 'upload' data from a ms-access database or a ms-ecxel-file and insert this data in a sql-server database.
The sql-server database remains on window-2000-server (of course) all the other stuff is transfered to linux (apache, tomcat and so on). The access-database or the excel-file will be uploaded on the linux-server as well. And i think this is the problem!
On windows-os the statement 'DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=access-mdb-location' and 'DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Excel Driver (*.xls)};DBQ=excel-file-location' works fine.
Is there a simular possibility on linux? I've allready installed unixodbc on the linux server but there is no driver for access or excel isn't it?
How must a odb.ini and the odbcinst.ini file look like?
Is there any freeware else?
Your help would be appriciated!
Best regards
gerald