yes, but I could change it if it would help

thanks, sounds good and I tried it.

But both versions are not giving the result. It was no error but simply the same as if I would sort without this ISNULL...

I am not sure if Access is the reason why it is not working or simply the SQL Server. So please all Access programmers look in the topic under SQL...

also don't forget to write a schema.ini file in same folder where the source or result table is written. here you specify for example the delimiter or the column names...

I found a solution myself:

sql = "UPDATE table_1 SET data_1 = REPLACE(data_1, CHAR(10), '')"

DoCmd.RunSQL sql

sql = "UPDATE table_1...