Graphics

I'm encountering a problem when I want to display a crawl driven by datalinq of 11 names from the players in a soccer-team ("00. Firstname Lastname"). The last characters of the last name is displayed not correctly... (XPression-Studio-6.5_3550)

This is the text in Excel:



This is within Datalinq (note the last name (#11) from Excel is not showing and instead there is are extra characters behind the #21 and a )


And this is what XPression makes of it...


When I decrease the number of characters in this crawl (instead of "firstname+lastname" only "lastname") the problem is gone.
So I suspect the Datalinq field is limited to a specific number of characters. Can somebody tell me what the limit is?
Thanks!

We've seen this problem before and it is caused by Excel itself.

Refer to this microsoft thread:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/41a17c1d-425c-4414-a8d5-dff521464df5/excel-data-import-truncate-data-length-to-255?forum=transactsql

You could try putting that line into a text datalinq to confirm the issue is no datalinq itself.



#XPression

Thanks Brian! Changing the value from "8" to "32" of the "HKEY_LOCAL_MACHINE\SOFTWARE\wow6432node\microsoft\jet\4.0\engines\Excel\TypeGuessRows" within Regedit, did the trick. Whenever I encounter more failing characters, I will increase the TypeGuessRows :-).
#XPression

Hi Rob, You might want to try setting it to zero instead.. I believe that tells Excel to scan the whole worksheet instead of only looking at the first X number of rows.
#XPression