|
|
Connection problem to an Excel File with ado.net (OleDb.OleDbConnection) |
|
Author |
Message |
dfrenchie720
|
Posted: .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
|
Posted: .NET Framework Data Access and Storage, Connection problem to an Excel File with ado.net (OleDb.OleDbConnection) |
Top |
|
|
|
Paul P Clement IV
|
Posted: .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
|
Posted: .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
|
|
|
|
|
|
|