TOPIC: text file adapter to access

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"

Hi Mark,

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?

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)

Most confusing in moment is lack of any warnings.

Hi Mark,

I guess you have changed some data types on the WRITE side. Please try to read in the table schema on WRITE side again.

The reason why only one record writes to the write side is the GroubBy Heater on the default layer! Remove this Heater/Functions and the definition could be work fine.

I've modified your definition. Have a look to the attachment and try it again, please.

thanks I have it now