![]() |
How can I read an Excel database in C#
Is there a way to read an Excel database in C# using the Jet.OleDB.4.0
engine. I am using the following instructions connection parameter: OleDbConn1 = new System.Data.OleDb.OleDbConnection("Provider=Micros oft.Jet.OLEDB.4.0; Data Source=c:/files/AccountPasswords.xls; Extended Properties=Excel 3.0"): When I try to open the file I get an error message saying that the Jet.OLEDB engine is not regisered for this machine. I have use this engine before on Access files and have never received this message. Does anyone know if it is possible to do SQL queries against an Excel database like Access or an SQL databse? |
All times are GMT +1. The time now is 12:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com