Excel JDBC/ODBC "Syntax error in field definition"
Posted on 2005-04-04
In my Java program, I export results to an Excel sheet, using the jdbc-odbc bridge.
It always manages to connect (ie. create the xls file), but then when executing the Create statement, it fails sometimes,
giving "java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error in field definition."
create table nameofTable (name TEXT, phone TEXT, amt TEXT, date TEXT, Status TEXT, Result TEXT, CallStart TEXT, CallEnd TEXT, Duration TEXT);
so once again: connect statement always works. create statement doesnt work sometimes, even though syntax is the same as when it does work.
sorry its so vague... but any ideas?