Hi Kartik,
Thanks for your information. I have moved on and solved my import problem another way, but I am still wanting to resolve this for next time. I am going to play with it some more since you were able to make it work. The two other vaiables I failed to mention were 1) the SQLyog version I am using is Ultimate v11.4 (64bit) and the Excel file was not actually produced by MS but by LibreOffice with the file saved in MS Excel 97/2000/XP/2003 (.xls) format. I’ll play with another Excel format and perhaps try using one produced by MS Excel directly and if I still have problems I’ll post an example file.
Shew