Excel as Database : Execute Non-Query : Update statement

Help
4

@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.

2 Likes