March 17, 2021
October 5, 2010
Can you please explain what you mean by dates prior to 1900 are not loading properly.
Looking at your file I see a column of dates. But most of these are negative values (date serial numbers) and you can't have negative dates. If that's the issue then you need to fix these dates to be valid.
July 16, 2010
Excel doesn't recognise dates prior to January 1, 1900, however Power Query can work with dates prior. So, while working with the dates in Power Query make sure they are data type: date. Then before loading to Excel you need to convert the column containing dates prior to January 1, 1900 to data type: Text so that they can be displayed in Excel as a date. Note: you won't be able to perform any calculations on these dates in the Excel table as they'll be text.