3
Reply

Error While making connection with Excel File

Vishal Goyal

Vishal Goyal

10 years ago
806

m trying to make connection with Excel. I have used many of connection string But no one is working.

**Connection String 1 Gives error-**The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

Filepath="C:\"

1-var ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Filepath + ";Extended Properties=Excel 8.0"

This Connection string Gives error string "Unspecified error"

2-var ConStr= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+Filepath+";Extended Properties=\"Excel 12.0 Xml;HDR=Yes;IMEX=1;\"";

        using (var conn = new OleDbConnection(ConStr)) {             conn.Open(); }

How to Choose right Connection string?

MY System Configuration:

Window Server 2008 R2 Sp1 Microsoft office 64 Bit. Visual Studio 2010 Professional


Answers (3)