LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Read Binary Database File [email protected] Excel Programming 7 February 9th 09 06:25 PM
read database William[_8_] Excel Programming 2 April 25th 06 06:08 PM
Achive and read Database Giovanna Excel Programming 2 August 28th 05 10:04 AM
How to read from a SQL Server table into Excel and use the Excel cell format as in the database Belinda Excel Programming 1 June 10th 04 04:45 PM
how to read excel spreadsheet into database (DB2) mairhtin o'feannag Excel Programming 1 May 31st 04 01:04 AM


All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"