External table is not in expected format + big sentence failed to load into excel
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;"
b) Big sentence not getting inserted into excel. it says field is too small to accept characters.
If I want to very big sentence into excel, what I'm supposed to use??