JDBC-ODBC for reading data from Excel files
843859Jun 21 2006 — edited Jun 21 2006I have project that needs to read data directly from Excel file. So I think simple JDBC-ODBC bridge will do. The most data are read correctly. However, when some column has mixed data type of text and number, it either return text data as null or number data as nul. I have set the type of column as 'text' in Excel file but it doesn't help at all.
One example is zip code. The column may look like this:
12345-0001
23456
....
12345-0001 should be treated as text by Excel and 23456 is number. One of this returns null when reading through Sun JDBC-ODBC driver, and other returns correctly.
Please help and if anyone had same issue before but solved the problem, please post your solutions and adivces.
Thanks!
Jeff