Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Read Binary Database File | Excel Programming | |||
read database | Excel Programming | |||
Achive and read Database | Excel Programming | |||
How to read from a SQL Server table into Excel and use the Excel cell format as in the database | Excel Programming | |||
how to read excel spreadsheet into database (DB2) | Excel Programming |