Truncated Excel field data with ACE Provider

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.

0
edit delete
are you sure?
asked John Morrissey

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions