Click here to Skip to main content
15,900,511 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

i am developing one desktop application , in that i want to import data from .csv file. I am using below connection string, but its showing error.

OleDbConnection connection = new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathOnly +
";Extended Properties='Text;HDR=no'")

I am getting could not find installable ISAM, So please give me correct connection string.


Try this lib: linqtoexcel[^]. I'm using it instead of ole, and it's easy and convenient.
Share this answer
Please ensure that the computer where you're running your Desktop application have latest MDAC components installed it to resolve this issue. Please refer the following articles for more information:

Microsoft Data Access Components (MDAC) Installation

Data Access Technologies Road Map

It is always better to avoid Jet driver for newer implementation.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900