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: 225

Filed under:

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?

Related posts about connection-string

Help with connection string

as seen on Stack Overflow - Search for 'Stack Overflow'
So I'm trying to connect to my database at the specified location, and the connection is established as long as the db at the same location specified at DataSource field, but what if I tried to distribute my application, the file path will change and will lead to errors I want to avoid. Here is my… >>> More
ADODB Connection String: Workgroup Information file is Missing?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a few data sources in access that I need to connect to programatically to do things with behind the scenes and keep visibility away from users. Said datasource has a password 'pass' as I'm going to call it here. Using this connection method I get an error attempting to use the open method Dim… >>> More
Do connection string DNS lookups get cached?

as seen on Stack Overflow - Search for 'Stack Overflow'
Suppose the following: I have a database set up on database.mywebsite.com, which resolves to IP 111.111.1.1, running from a local DNS server on our network. I have countless ASP, ASP.NET and WinForms applications that use a connection string utilising database.mywebsite.com as the server name, all… >>> More
Dynamic connection for LINQ to SQL DataContext

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
If for some reason you need to specify a specific connection string for a DataContext, you can of course pass the connection string when you initialise you DataContext object. A common scenario could be a dev/test/stage/live connection string, but in my case its for either a live or archive database… >>> More
Logging connection strings

as seen on SQLIS - Search for 'SQLIS'
If you some of the dynamic features of SSIS such as package configurations or property expressions then sometimes trying to work out were your connections are pointing can be a bit confusing. You will work out in the end but it can be useful to explicitly log this information so that when things go… >>> More

Developer IT