Question

ERROR [HY104] [Microsoft][ODBC Excel Driver]Invalid precision value ERROR Invalid precision value

Workflow Version 10

Updated August 28, 2024

asked on May 16, 2017

Having an issue inserting large text fields to Excel. They're only about a total of 700 characters, and I know that the Excel cell limit is around 33,000 characters, so not sure why I'm having such an issue. Is there a limit to characters when inserting from Workflow? Thanks!

0 0

Replies

replied on May 16, 2017

Workflow doesn't do any trimming on the data. The error is from the driver. The message seems to indicate that it's an issue with the number of decimals, so Excel thinks that's a number column.

0 0

View 1 previous reply

replied on May 16, 2017

Update: in order to completely remove that from speculation, I formatted the Excel fields in question to Text - same error

0 0

replied on May 16, 2017

Column formatting in Excel doesn't matter, it's for display only. Excel guesses the column data type internally by sampling the first few rows (8 by default). This internal data type is used in ODBC queries. So when the driver tries to write to a column with mixed types, all values will be checked against this internal data type.

0 1

replied on May 22, 2017

So when everything's text and all other columns are doing fine except those that are lengthy, what does that mean?

0 0

replied on July 6, 2021

I am having the same problem with Workflow 10.4.3 and ODBC for Excel 12.0 (driver version 14.00.7010.1000) when inserting long text (string of semi-colon-separated dates) in an Excel column. Have you been able to find a resolution or workaround?

0 0

replied on June 10, 2022

Hello
we are having the same problem, is there any solution you can share?

0 0

replied on June 20, 2022

I ended up splitting the one big workflow into several workflows - each one processing a fraction of the dataset. It's working so far.

0 0

replied on August 28, 2024 • Show version history

I was getting the same error when inserting /updating LongText field in Access table for .accdb if text is longer than 255 characters in Notes field on my form.

I used OLEDB.12 instead of ODBC. See this post for more details, which works for MS Access. I hope that works for you as well.

0 0

You are not allowed to follow up in this post.

Question

Question

ERROR [HY104] [Microsoft][ODBC Excel Driver]Invalid precision value ERROR Invalid precision value

Replies

Sign in to reply to this post.