Excel file reading with 2007 office connection string.
Posted
by p-vasuu
on Stack Overflow
See other posts from Stack Overflow
or by p-vasuu
Published on 2010-04-21T17:32:47Z
Indexed on
2010/05/04
12:38 UTC
Read the original article
Hit count: 229
connection-string
Actually in my system having 2007 office then i am reading the 2003 .xls file with using the 2007 connection string
string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Filename + ";Extended Properties=\"Excel 8.0;HDR=YES;\"";
data is not reading. But if the first row first column data length is lessthen 255 then the following first columns data is cutting up to 255 character. If the First row first column is morethan the 255 character then the following first columns data is reading fine.
Is there any back word computability is there?
© Stack Overflow or respective owner