ODBC to Excel worksheet and formula updates

[Anil_G (Anil Gorthi)]

@Phil_Kelsey

Can you please shwo the detailed error

Also did you try with updating any single value like A

If its happening for any cel then try this

Excel as Database : Execute Non-Query : Update statement

@Sarath In Connection string Change “IMEX=1” value from 1 to 0 or -1, It will work. if IMEX value is 1 can only do read operation on data in excel. if IMEX value is 0 or -1 u can do read, write and update operation on data in excel.

Cheers