Connection problem to an Excel File with ado.net (OleDb.OleDbConnection)  
Author Message
dfrenchie720





PostPosted: .NET Framework Data Access and Storage, Connection problem to an Excel File with ado.net (OleDb.OleDbConnection) Top

Hi everyone,

I'm trying to add tables and data to an excel file with ado.net
And I got this message : Driver ISAM not found while it's trying to open the connection

I let you my connection string, I don't think there is error, neither in the register because, I checked it.

olecon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & My.Application.Info.DirectoryPath & "\..\" & "Activity.xls" & ";Extended Properties=""Excel 10.0;HDR=YES"""
olecon.open()
I'm using Excel 2002 on the computer.

Is soemeone ever had this problem

thanks

david



.NET Development12  
 
 
DMan1





PostPosted: .NET Framework Data Access and Storage, Connection problem to an Excel File with ado.net (OleDb.OleDbConnection) Top

Since you are having a driver issue...I would see if installing the latest and greatest MDAC will solve your problem:

http://www.microsoft.com/downloads/details.aspx FamilyID=6C050FE3-C795-4B7D-B037-185D0506396C&displaylang=en



 
 
Paul P Clement IV





PostPosted: .NET Framework Data Access and Storage, Connection problem to an Excel File with ado.net (OleDb.OleDbConnection) Top


There is no Excel 10.0 Extented Properties setting. The driver hasn't been updated since 8.0 so you should be using this version.

 
 
dfrenchie720





PostPosted: .NET Framework Data Access and Storage, Connection problem to an Excel File with ado.net (OleDb.OleDbConnection) Top

ok, i will try both of your solutions.
The fact that, when I was using 8.0 in the connection string, it was unable to create me table, and now the ISAM problem always appears.
I let you know later how it advances