How to read data in Excel?

Posted by Naresh2k3406 under C# on 3/2/2012 | Points: 10 | Views : 1858 | Status : [Member] | Replies : 5

What is the connection string need to be used to read from excel irrespective of the version(2003, 2007, 2010) in c#?

Reply | Reply with Attachment

Posted by: Vforvijay on: 3/2/2012 [Member] Starter | Points: 25

0	hi.. Refer the below link..... http://www.dotnetcode.in/2011/01/import-excel-table-into-sql-table.html Naresh2k3406, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naresh2k3406 on: 3/2/2012 [Member] Starter | Points: 25

0	This site is blocked. Please send the code. Naresh2k3406, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sksamantaray on: 3/2/2012 [Member] Silver | Points: 25

0	The site is opening.Try to open the site in different browser. Thanks, Sanjay Naresh2k3406, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Kk86kiran on: 3/2/2012 [Member] Starter | Points: 25

0	hi, this is for ms office 2003 <connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\|DataDirectory\|\MyDb.mdb;Jet OLEDB:Database Password=123" providerName="System.Data.OleDb" /> you just change version number 12 instead of 4.0 in provider option for ms office 2007 k.m.j.kiran Naresh2k3406, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: perfectchourasia-9163 on: 4/3/2012 [Member] Starter | Points: 25

0	http://sandeep-chourasia.blogspot.in/2012/04/read-excel.html ER sandeep chourasia sandeepchrs@yahoo.com (on facebook) http://www.aspnetcodes.com/ Naresh2k3406, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts