Query '' is corrupt.

[EricLi]

​​Hi, I am suffering a process which update a field in an excel by OLDDB. It works well from day 1 launched until last week. My connection script and SQL string as below:

connection script:     "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[DBPath]&";Extended Properties='Excel 12.0 Xml;HDR=Yes';"
SQL:     "Update [Sheet1$] Set [Processed Flag]= 'Y' Where Len([Type])>0"

I have tried to set IMEX from 0 to 2, even create a new excel and set all cells to Text format. But all ways got the same error said: "Internal : Could not execute code stage because exception thrown by code stage: Query '' is corrupt."

------------------------------
Eric Li
Operation Analysis
AIG
Asia/Hong_Kong
------------------------------

[GopalBhaire]

Not entirely sure but a quick search suggest that this might be an issue with Office Update of Nov. (check out your build)

https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

[EricLi]

​Thanks Gopal

Checked out the build we have in excel. They are all the same build and do not in the list Office suggested. And very strange that only 1 process suffer this issue. Others works well.

------------------------------
Eric Li
Operation Analysis
AIG
Asia/Hong_Kong
------------------------------