I’ve been attempting to write to a Microsoft Access database (*.accdb) from KNIME. I can read the database using the database reader. And, if I write from the database reader to the database, I am successful. However, when attempting to write to the same database while using another file as the input, I get the error message:
Execute failed: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
What should I be doing to successfully write to the database?
Any and all suggestions welcome.