Parse the file yourself.

http://support.microsoft.com/support...eio/fileio.asp
File Access with Visual Basic® for Applications

--
Regards,
Tom Ogilvy

"Nick Thomas" wrote in message
...
Hi,
I have a text file that has a column of MMMYY (i.e.
AUG03). In Excel 97, the OpenText method would interpret
this as 1st August 2003 and display it (in UK format) as
Aug-03. In Excel 2000, it interprets is as 3rd August 2003
and displays it as 03-Aug, ie. it doesn't assign the first
day of the month as the day portion of the date. Similarly
Dec-05 is imported as 5th December 2005.

I've tried out all the xlColumnDataType values but they
all return the same.

Any ideas?

Many Thanks
Nick