>>>By the way it was an xslx file which I saved as a xls file
>>
>>Well if you have the luxury to save it in a different format, why not CSV?
>
>
>cav worked fine
>
>sorry I meant why didnt the xls file work
Because MS changed something.
If you use MS Office 2010 or newer you should save XLS as Excel 5.9/95 format.
97 format works only if you have MS Office 2007.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.