Forum Discussion
Date errors when importing csv file to Access -
Hello, everyone, I encounter the following error when importing csv file to access. Can someone advise me how to make Access read the data correctly? I exported a csv file including a date column f...
Blood4Iron The import usually looks at the Excel cell types for the first few rows. Looks like although your values in EventDate look like a date, they are formatted as General. I would try formatting them using the custom m/d/yyyy h:mm option in Excel. Then make sure on your import mapping they are mapping to the type Date with Time
