Excel 2007 : Import of date time data fails

I am trying to work with large data files available only as a .txt file (comma separated data).

Company A provides it as dd/mm/yy hh:mm:ss. The import function cannot handle this.

Company B provides the data as mm/dd/yy hh:mm:ss

The import function works fine if A and B do not include the time.

My example is simple. Paste the following into notebook and attempt to import it. The dates are June 12 and June 13.

DAY MONTH,MONTH DAY
12/06/12 18:06:12,6/12/12 18:06:12
13/06/12 18:06:12,6/13/12 18:06:12

I have found work around. Changing my regional setting from English(US) to (English(UK) will allow me to import company A. It's a ugly solution.

@dmang1. did you post the same reply twice, or is it just appearing twice? just curious

import but use both , and space as delimiters set the first field to dmy and the other date field to mdy