There didn't seem to be any posts on the internet for a solution to this problem.
Background
I've written a vba macro that takes data from Excel, processes it into an XML file & then imports into Access.
All fields were fine apart from the date field, which appeared in the Access table as...