How to work with Microsoft.Jet.OLEDB

Posted by Oswaldlily under ASP.NET on 2/7/2014 | Points: 10 | Views : 872 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved 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

0	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

Latest Posts

Zipping of excel files using c# (0)
How to install Redis cache in Windows (0)
Angular Material Datepicker is not working (0)
Optimizing assemblies for performance failed. You can either exclude the failing assemblies (0)
Please help me on below interview questions (0)
Views folders are not getting published in .NET Core 3.x (0)
Points Not Display On Google map Although I Pushed Latitude And Longitude (0)
code first migration error in mvc (1)
More ...