I'm trying to find the connection string/parameter combination that will allow me to read from an Excel (either 2003 or 2007) file where the field contains > 255 characters. I've tried the ACE string below but fields get truncated.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";
I did find that the Jet driver will work, but I've been seeing intermittent errors. Is there another parameter or provider I could try? Any info would be appreciated.