Finally I was able to see the image you posted (better explain it by words), and understood that some of the values (those with $ in it) return as empty...
The problem is that Excel has no data type, so the OELDB driver have to decide what datatype to assign to every column upon reading it...
In case of mixed types the driver will decide using a look-ahead method, where it will check a certain number of rows and will decide according the majority - in your case the driver decided that this column is numeric and wiped out any non-numeric values...
You can change it by adding some extended attributes to the connection string...
Extended Properties=\"HDR=YES;TypeGuessRows=0;ImportMixedTypes=Text\"
This will tell the driver to read the first row as header-text, do not do any type guessing and use Text as type for mixed columns...
There is more info about Excel connection here:
https://www.connectionstrings.com/excel/[
^]