Hi All,
We wrote a logic which uses a Excel file as a database and reads data from it. We executed the logic successfully in my local system which is using windows xp as an operating system.but when i uploaded the code in the client’s server which is running on the unix platform.We got “Null Pointer Exception”.
Here is our code snippet:
Class.forName( “sun.jdbc.odbc.JdbcOdbcDriver” );
c = DriverManager.getConnection(“jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=” + “Name of the file”);
Actually the problem is the ODBC-JDBC driver which we are using will support only for Windows Platform.In server it is in UNIX platform.JDBC-odbc bridge driver can’t support MS Excel on Unix.We need to run sql queries on Excel files in unix platform.
is there any way to solve this problem.please guide us to solve this problem.
Please give your valuable suggestions.
Thanking You,
Regards,
Java Team.
