>>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.