How to work with Microsoft.Jet.OLEDB

Posted by Oswaldlily under ASP.NET on 2/7/2014 | Points: 10 | Views : 1246 | Status : [Member] | Replies : 1
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


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

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