I am trying to get it work but no luck so far.
Have csv data and trying to write access.
by test run I get read 24, Fitter 24, write 1 (!)
No warnings! So it simply refuses to write file
By execute I have almost same result exept write 0 and "Syntax error in UPDATE statment"
If you want UPDATE records FlowHeater updates only records how can find matches. This is the reason why READ 24, Fitter 24 and WRITE 1. In this case FlowHeater has only found one match for UPDATE on WRITE side.
I don't know why the error occurs. Please try the follows. Open the Access Configurator on the WRITE side and switch on the “Generate SQL Script” property and execute the definition in test mode again. I need the generated SQL script and the FlowHeater definition file for more analytic. ZIP these two files into one archive and post it here.
One more question. Runs the example "Menu->Examples->AccessAdapter->CSV Import" without errors?
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
I got rid of error if removed primary key "auto increment" but probably it is not right thing to do.
Also noticed that despite the fact that it should write all new data for now it writes only the last row from csv file, regardless number of lines or actual data in that line.
haven`t tested example csv yet. (should probably do)