How to read data in Excel?

Posted by Naresh2k3406 under C# on 3/2/2012 | Points: 10 | Views : 927 | 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#?




Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response