Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1280
Home > Forums > ASP.NET >

How to work with Microsoft.Jet.OLEDB

Posted by Oswaldlily under ASP.NET on 2/7/2014 | Points: 10 | Views : 1074 | Status : [Member] | Replies : 1
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
why Microsoft.Jet.OLEDB not working in Excel 2010..

I tried Microsoft.Ace.OLEDB which worked..

But can u say how to work woth Microsoft.Jet.OLEDB in excel 2010



Reply | Reply with Attachment
Alert Moderator 

Responses

Posted by: Snaveen on: 2/13/2014 [Member] Starter | Points: 25

Up
0
Down
did you get any error..?
I think the problem is connection string try to use below sample. 

OleDbConnection oconn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties=Excel 8.0");


Hope this will help you...

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response

Latest Posts