HI Team,
a)
While connecting with excel, I'm using below connection string. But it giving as error "Extrenal table is not in the expected format". Kindly help me to resolve
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 12.0;HDR=Yes;ReadOnly=0;"