As discussed, some of the machines use U.S. dates (e.g. today would be '03/16/13', and some use U.K. dates (16/03/13). We need all dates to be treated in U.K. format (dd/mm/yy). I was thinking to add a column to the Machine table for 'DateFormat' - then when we import the file, for US dates it would convert to UK format.
Attached are some sample file and updated data file - I have added a column to the machine table. Let me know if there are any questions?