开发者

Excel file reading with 2007 office connection string

开发者 https://www.devze.com 2022-12-28 04:42 出处:网络
Actually in my system having 2007 office then i am reading the 2003 .xls file with using the 2007 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?


I All

I solved this issue, by changing the connection string.

vasu

0

精彩评论

暂无评论...
验证码 换一张
取 消