I am using the Microsoft Jet Oledb as my driver to load the excel files. The issue I am facing is it does not extract all the data from the excel file. It thinks certain fields are float so it will only select the rows in the excel which are numeric.
When I run the select query from the data base it would pick up the rows 1,2,3 but for row A the field data would be null. Is there a setting where I can set everything coming from the excel file to be varchar?
View Complete Post