topic RE: Query '' is corrupt. in Product Forum

Query '' is corrupt.

EricLi — Mon, 25 Nov 2019 02:35:00 GMT

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

RE: Query '' is corrupt.

GopalBhaire — Mon, 25 Nov 2019 07:29:00 GMT

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

RE: Query '' is corrupt.

EricLi — Mon, 25 Nov 2019 08:45:00 GMT

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