How to work with Microsoft.Jet.OLEDB

Posted by Oswaldlily under ASP.NET on 2/7/2014 | Points: 10 | Views : 956 | 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

How to handle 302 status (Moved temporalily) (1)
Failed to find a valid digest in the 'integrity' attribute (1)
Angular Template parse error occured while rendering 3rd party website in ASP.NET (0)
How to display 2 tables in a single line in 2 div tag (1)
I Want to Do a multiple selector on ASPnet MVC (0)
Get all materials of parent and its children in an array except for few (0)
Container in Media Query (0)
How to send keys to specified app with title? (1)
More ...