Writing to MS Access

Dear KNIMErs,

A new challenge every day. :slight_smile: I need to write a pretty massive table (75M rows, 185 cols of double values) to MS Access (as the supposedly most compact format I can get onto a local drive without admin privileges). However, MS Access complains about ERROR Database Writer Execute failed: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement. :frowning:

Any ideas?


Hi E.,

This fix is to adjust the SQL column types in the "SQL types" tab within the dialog. As far as I know, removing the precision from the numeric(...) fields should help - at least for MS Access databases.

Regards, Thomas