>>Is it by any chance in Excel 2007 format?
>I don't know. Is there any way to examine the file to find out? Either some property I can find out in Excel or via looking at some specific bytes in the file.?
>
>>If yes, then this problem was already discussed here and IMPORT function is not going to work.
>
>Ouch.
>
>Thanks a bunch for responding.
>
Rich,
Please check this thread
Checking the version of an Excel File Thread #
1260311 and also thread referenced there.
If it's not broken, fix it until it is.
My Blog