I am looking to automate an import of an excel worksheet provided by an insurance company. Unfortunately the date fields on the worksheets are not formatted correctly. The dates are displayed as 9192018 instead of 9/19/2018. I have tried to format the dates while importing in access but it converts the dates into nonsense (generic 12PM Time, 1499 dates, etc.) I have also tried to format the dates in excel prior to importing them in Access but that doesn't work either (It shows nothing but ##### and the error says "dates and times that are negative....").
Is there a way to format all date values that are mddyyyy to m/dd/yyyy automatically while importing to access? Thank you in advance for any help/direction you can provide.
A few examples of the dates:
PolExpDt
1012019 12312018 1012019 9012018 9182018 10042018 11202018 9012018 9062018 11042017