Graphics

I am having an issue i haven't seen before. For some reason I can not see numbers in my excel sheet when linking the sheet.

I have tried to make the cells formatted as numbers, text, and they are back to General.

Please see images attached. (excuse the crude sensor ship via the red ) Yellow arrow points to one example.

Thanks,

If you are using a 64bit version of windows, and are using the Jet OLE DB driver in the ADODB datalinq, then in the windows registry edit this key

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ Jet\4.0\Engines\Excel]

and set TypeGuessRows = 0

If you are on a 32bit windows the key is probably called:[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ Jet\4.0\Engines\Excel]

The reason for this is that the Excel database driver (not XPression, but excel itself), looks are the first few rows in a column and tries to determine what data type is contained in that column. So if the first few rows are all text is assumes everything should be text and not numbers, etc. It does not use the cell format defined in excel for this.

Setting that registry key to zero will force excel to look at the entire column and not just the first few rows before it decides on the data type.

#XPression

You can also run into this when a field contains more than 255 characters. Here is a link to Microsoft's description of the problem.

https://support.microsoft.com/en-us/kb/189897

#XPression

Thanks for the quick reply bford.
I have done everything above and still am running into the same problem.
#XPression

Ok, contact Ross Video Tech Support and send them the Excel sheet and Datalinq DSC config file so they can investigate the issue.

You are using the Jet driver and not ACE, correct? (Look at the connection string in the ADODB datalinq settings).
#XPression

Yes I am using the Jet driver.
#XPression

Did anyone ever find a solution to this? I'm having the same issue and have also tried everything above.

It seems when I manually enter the data (in my case; minor league baseball season stats) everything shows up fine. But when I copy it from the website into a blank excel sheet, manipulate the data how I need it, and then copy it into my excel databases - that's when I have the problem.
#XPression

Can you upload your excel sheet that is having issues here?
#XPression

@shrantz4485 I've downloaded your sheet, but I don't know which fields you are having trouble with.. Can you provide more info about where to look?

Here is what I am seeing in datalinq for one sample table:

#XPression