After looking into this further I was mistaken in thinking that the date was interpreted by one ADO connection and not another. I can't get anything to convert the supplied number as a valid date.

So I'm going to try and track down the people who are exporting the data and see what's going on.

I'll post here when I make any progress. Thanks for the help so far.