Hello all,
I had been using OLEDB to change three fields within an excel sheet based on the value in the field. It had been working up until a couple days ago. Now I am receiving an error on the execute Query stage. The error I am receiving is : Internal : Could not execute code stage because exception thrown by code stage: Query '' is corrupt. The file name is dynamic and so I have a multi-calc setting the values and storing them in a data item. The information i used can be seen below.
Database String: [File Folder Path] &"\"& [New Workbook Name] & ";Extended Properties=""Excel 12.0 Xml;HDR=YES;"""
Provider String: "Microsoft.ACE.OLEDB.12.0"
Connection String: "Provider=Microsoft.ACE.OLEDB.12.0; Data Source="& [File Folder Path] &"\"& [New Workbook Name] &";Extended Properties=""Excel 12.0 Xml;HDR=YES;""" & ";"
Query: "UPDATE ["&[Worksheet Name]&"$A2:DO] SET [Field 1]= 'Value 1', [Field 2]= 'Value 1', [Field 3]= 'Value 1' WHERE [Field 1] = 'Value 2';"
I have tried doing a get as collection stage instead and I am able to get the fields I am trying to change as a collection but would still get that error when trying to update the workbook. I'm inclined to think it doesn't have to do with the connection since I am able to do other queries and get data as a collection. I double checked field names against what I have written and everything matches up. I had been using that exact query string and it worked for a while with no issue. Any help would be appreciated.
------------------------------
Bryant Backus
------------------------------
