Excel VBA error "Query ' ' is corrupt" while executing update query using ADODB.Connection & Microsoft.ACE.OLEDB.12.0

Asked Dec 04 '19 at 19:55

Active Dec 04 '19 at 19:55

Viewed 236 times

I have an update query in Excel 2013 vba. Till recently it worked. Now I got the error "Query ' ' is corrupt" in the "adoConn1.Execute" command. I know there is an Access Issue caused by November Office update. The problem is that I got the error in Excel and the problematic Office updates where not installed in my PC. Can you help me?

strUpdateQuery= "Update [Table$] " & " SET FieldName = " & FieldValue

sConn1 = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & PathDB & "\" & FileNameDB & ";" & _
"Extended Properties=""Excel 12.0;HDR=YES"""

Set adoConn1 = New ADODB.Connection
adoConn1.Open sConn1
adoConn1.Execute strUpdateQuery, flagUpdateResult, adExecuteNoRecords

adoConn1.Close
If Not adoConn1 Is Nothing Then Set adoConn1 = Nothing

asked Dec 04 '19 at 19:55

user3340983

2

You are still using Microsoft.ACE.OLEDB.12.0 which is Access. Have you gone through https://stackoverflow.com/q/58832269/11683? – GSerg Dec 04 '19 at 19:58
It did not help me. I searched "KB4484119" in order to uninstall it but did not find it. I didn't find any recent update relevant to Office. I keep getting this error in Excel. – user3340983 Dec 04 '19 at 20:35
The error number is 2147467259 (800040005) – user3340983 Dec 04 '19 at 20:37
Have you tried the suggested workarounds? – GSerg Dec 04 '19 at 20:49
You mean replace: Update TableName .... with "Update (SELECT * FROM TableName"?. I will try it. – user3340983 Dec 04 '19 at 21:30

Excel VBA error "Query ' ' is corrupt" while executing update query using ADODB.Connection & Microsoft.ACE.OLEDB.12.0

0 Answers0