ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I read an Excel database in C# (https://www.excelbanter.com/excel-programming/424975-how-can-i-read-excel-database-c.html)

parrot

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