Click here to Skip to main content
Click here to Skip to main content
Go to top

Microsoft OLEDB Adapter for Microsoft Excel 2007

, 17 May 2009
Rate this:
Please Sign up or sign in to vote.
Microsoft OLEDB adapter for Microsoft Excel 2007.

Introduction

This article is for developers who want to play with different Office files (*.csv, *.xlsx, *.xls, *.doc) without Office being installed on the machine, by using Microsoft OLEDB Jet drivers. I am writing this article to just help you out with Microsoft Jet OLEDB problems with Microsoft Office 2007.

Background

Recently, I was working on my application for dynamic data to get data from Excel sheets. I was using Microsoft Jet OLEDB drivers for Excel 8.0 ISAM. It was working fine with *.xls extensions. But, I came across the problem of Microsoft Excel 2007 *.xlsx not working with Microsoft Jet OLEDB for Excel 8.0. One of the reason might be ISAM missing for Microsoft Excel 2007.

Using the code

I will not be explaining the whole phenomenon of getting Excel sheets from an Excel file and getting data from these sheets. You can find an article on working with Microsoft Jet OLEDB with Excel from CodeProject. However, I will guide you through the problem of connecting Excel 2007 with Microsoft Jet OLEDB.

What you have to do is change the connection string as follows. Remember to test this. You should have Microsoft Office 2007 (or Microsoft.Ace.Oledb components installed that you can find at: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en) installed.

private string mExcelCon = @"Provider=Microsoft.ACE.OLEDB.12.0;";

private string mConnectionString; 
mConnectionString = mExcelCon + "Data Source=" + fileName + 
                    ";Extended Properties=" + Convert.ToChar(34).ToString() + 
                    "Excel 12.0;HDR=Yes" + Convert.ToChar(34).ToString();

Microsoft.Ace.Oledb 12.0 supports all Microsoft Excel versions up till 2007.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author


Comments and Discussions

 
GeneralMy vote of 1 PinprofessionalBillW332-Sep-14 2:48 
GeneralMy vote of 1 PinmemberSyed Javed9-Jan-13 3:01 
GeneralMy vote of 1 PinmemberAamer Alduais28-Apr-12 22:26 
GeneralMy vote of 2 PinmembereOrdinary22-Jul-10 22:25 
GeneralMy vote of 1 PinmemberITMaiO21-May-09 4:56 
QuestionDoes it is not really obvious? Pinmembercybertone17-May-09 20:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.140905.1 | Last Updated 17 May 2009
Article Copyright 2009 by Abdul_Qayyum
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid