Graphics

I am using Datalinq to pull in information from Excel. I have a player with a jersey #00; however, when I convert the Excel cell to a text format , Datalinq does not recognize any information in that certain cell. When I try to format the cell to display 00, Datalinq only reads the cell as #0. Has anyone else ran into this same problem, and how did you go around solving this issue?

I am not very knowledgable on scripting, but could there be a way to script out when the text value from Datalinq shows #0, it can display #00? Thanks.

You're converting the excel file to a text format? Is there a reason to do that; have you tried importing it as a ADODB database?
#XPression

Try this:

If you are using XLS files (not XLSX) and using the JET OLE db connection string, in RegEdit, navigate to this registry key
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ Jet\4.0\Engines\Excel]
and set the TypeGuessRows field to 0.

If this doesn't solve the issue, you'll need to share the XLS file with us to investigate.
#XPression

Is there a similar key for XLSX files? I seem to recall having this issue myself and I set a bunch of those registry keys to no effect. Ended up just hard coding the jersey number on the take item itself.
#XPression

This may help. I have not tried it myself though: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/41222f92-b079-4e6c-ae17-3aa3534a45a7/setting-typeguessrows-for-excel-ace-driver?forum=sqlintegrationservices

#XPression

I am interested in learning if this worked. I am having the same problem with an Excel database.

Update: I am only having the problem on the actual Xpression machine. Just started trying to troubleshoot on an offline system and am not seeing the same result. My "00" are displaying properly on my offline machine.
#XPression