I am importing
.xlsx to SQL but whenever I am importing from a large
.xlsx file it gives me error :
"External Table is not in expected format"
and whenever I am deleting some rows it runs fine. I have changed the Run64bit runtime to False. Still issue persists.
I am using SQL 2008R2.
Also when I change it to
.xls and build package in SSIS 2005 it works.
The connection string I am using is
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + @path + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES\";