You must Sign In to post a response.
  • Category: ASP.NET

    External table is not in expected format + big sentence failed to load into excel

    HI Team,

    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??
  • #769889

    Can you share your code .

    May be your content length compare your db also.

    Name : Dotnet Developer-2015
    Email Id :

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • Sign In to post your comments