I am having an issue when using the import wizard with an excel file that has numbers or dates as headers. for some reason, the headers that are not text are appearing as null values. For example: I have a table with multiple headers that are dates. These all show up as <Null Column *> for all of the columns that has a date as the header. I have confirmed that the data type is Date on the excel file. This appears not to be limited to date formats, I tried this with some numerical values and see the same thing, the text headers are there while numeric are all null.
I am using data point 3.8 and the excel version is pro 2010
Any help is greatly appreciated.