Question

Trying to insert data into Excel and get "operation must use an updateable query"

Forms Workflow

Updated February 27, 2018

asked on August 25, 2014

The problem I am trying to solve. I have a form that contains a table where multiple rows can be added. I need all of the data in the table to be inserted into an Excel spreadsheet where additional calculations will be completed.

Here is my form:

Then I have a workflow that takes the form data and creates a document per row and associates the data in the row to template fields.

Below is the workflow:

So the last thing I need is for the data being stored in the template fields to also be written to an Excel spreadsheet (see attached). I created an odbc connection to the Excel spreadsheet and the test connection works but when I run the workflow I get this error.

From what I've read I should be able to push data to Excel so I'm not sure how to troubleshoot this issue. I've tried using other spreadsheets but get the same result.

Can someone point me in the right direction?
Thanks

Sandy

DPWSharedServices.xls (81 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on August 25, 2014

Can you check your ODBC data source definition (in Windows)? Excel defaults to using read-only connections which would generate that error. See http://support.microsoft.com/kb/316475

1 0

replied on August 25, 2014

That was it Miruna - Thank You!!!

0 0

Replies

replied on August 25, 2014

ODBC can get annoying. I would recommend closing out your workflow designer and then trying the workflow. sometimes when I try to test a connection from the Insert Data or Query Data activities, it does not give up the connection before my WF tries to use it. Not sure if that is the error I would get in those situations.

Also, what exactly are you doing for these spreadsheets? Are you trying to store just the current row of information? I am confused by the order of operations in this workflow. I think you mean to use the create entry outside of the loop, or, use the values for "ForEachRow" and not the table tokens directly.

0 0

replied on August 25, 2014

Thanks for your response. Closing the workflow designer didn't help. I am trying to get each row in the table on the form to be a row in the Excel spreadsheet. The workflow will create a new document for each row in the table and associate a template with the data for that row. All is working fine there. I even tried creating a second workflow that just retrieves the data from the template once it is stored then inserting it into Excel but I get a similar error.

Thanks

0 0

replied on August 25, 2014

That Error in the beginning of the message is more like what i would get when running into two things accessing the same ODBC connection. Remember, only 1 instance of anything running can use a connection at a time. It's an annoying limitation that can cause all types of weird interactions if you use the same ODBC connection for multiple workflows/workflows running at the same time.

0 0

replied on September 30, 2015

Hello,

Kindly i have the same error when i try to writ on Excel sheet, also i had fixed the DSN but still not working.

any idea?

Regards

0 0

replied on October 1, 2015

This is not a Laserfiche error, so we can't really help you. Try the other solutions suggested by a search for the error message.

0 0

replied on October 3, 2015

Thank you for your reply

i checked and its working fine now

0 0

replied on February 27, 2018

Hi...Afnan Al Zayani,

Would you like to please tell me how you solve this error message ?

I am receiving same message..When I insert the data in EXCEL through ODBC.

Thanks

0 0

You are not allowed to follow up in this post.

Question

Question

Trying to insert data into Excel and get "operation must use an updateable query"

Answer

Replies

Sign in to reply to this post.