How can I write to MS Access? I constantly get an error:
Execute failed: [Microsoft][ODBC Microsoft Access Driver]Invalid SQL data type
The table has Text and Number (Long Integer) fields. I tried varous combinations of sql types but none of them worked. (varchar, text, Integer, Long, Number,...)
What are the correct types for MS Access using JDBC-ODBC bridge?