https://support.microsoft.com/zh-cn/help/189897/ The data-truncated-to-255-characters-with-excel-odbc-drivermicrosoft.ace.oledb.12.0 driver reads Excel and reads the first 8 rows to determine the data type of each column. If there is no more than 255 characters, then it will be set to nvarchar (255), starting from line 9th, more than 255 characters will be automatically truncated! Recommended use of third-party libraries: Https://github.com/ExcelDataReader/ExcelDataReader----------------------------------attached string microsoft ACE OLE DB 12.0provider=microsoft.ace.oledb.12.0;data source=c:\myfolder\myexcel2007file.xlsx; Extended properties= "Excel 12.0 Xml; Hdr=yes "; Driver download Microsoft Access Database redistributablehttps://www.microsoft.com/en-us/download/ details.aspx?id=54920
When reading Excel with OLE DB, the cell content length exceeds 255 truncated