How can I read an Excel database in C#

P

Parrot

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=Microsoft.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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO connection to Excel 2007 *.xlsx files? 8
How to read index value and selected text of dropdown excel in C# 1
VBA Excel data to SQL Sever table 1
Importing .xlsm, .xlsx with OLEDB 5
Get results from Access Database. 2
Macro doesn't work any more 0
Excel Data Truncated to 255 Characters 0
ADOBO control of Access Make Table query 0

Top