Graphics

Hi,

We've encountered a very weird problem with an Excel Datalinq we are using. For one of our stat tables, some of the rows with information are coming up as empty (as seen in the first picture), but in our table for the entire sheet that stat table is contained, those stats are populating correctly (as seen in picture two). For the stats in which we are encountering the problem, all of the text is formatted as general and the datalinq connection we are using is the ADOBD source set to the mixed numeric/text data template. I've personally have never seen an issue like this until now and would appreciate any help.

Did you ever find a solution to this datalinq-ADODB connection? I am having the same issue.
#XPression

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