Failed To Retrieve Long Data For Column

• thelenj

  SSC Eights!

  Points: 869

  More actions

  April 29, 2022 at 2:38 pm

  #4024277

  When importing from an Excel spreadsheet I get the error: "Failed To Retrieve Long Data For Column <column name>"

  The data in the column is text.  If the first few rows of data are short strings (<100 characters) then the process fails for the entire file; however, if the first few rows of data contain long string (500+ characters) for the entire file.  It looks as if some data type is being set on the first few rows of data and if later on in the file the data gets longer it fails; however, if I start with the longer strings up front the process handles subsequent shorter strings just fine.

  What I need this process to do is just accept any data length for these columns of text and stop trying to guess (too low) based on the first few rows.

  Based on cruising around the net the following suggestions have been made and implemented to no effect:

  1. For the Excel data connection include attribute IMEX=1
  2. In the registry, for  TypeGuessRows the value has been set to 0.

  So is there any way to force the Excel Data Connection to just assume all columns contain at least string lengths of at least 4000 characters instead of trying to guess way too low on a few rows of data?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  April 30, 2022 at 3:10 pm

  #4024759

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.