Resources For IT Professionals

United States (English) Drop down arrow

Россия (Pусский)中国（简体中文）Brasil (Português)

Post an article

Wikis - Page Details

First published by Rakesh Parida MSFT (eMicrosof)
When: 15 Dec 2010 2:33 PM
Last revision by Naomi N (eMicrosoft Partne)
When: 9 Jul 2013 12:28 PM
Revisions: 7
Comments: 1

Options

Subscribe to Article (RSS)

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

SSIS: Excel Connectors

SSIS uses the JET provider under the covers to access earlier versions of Excel and Access. That is what happens when you use the Excel connection manager, which is a wrapper around JET provider. By the same token, connectivity to Access is also currently wrapped around JET, and offered by a special user interface in SSIS.

If you are dealing with Office 2007, you must use the new ACE provider, please see the page on Office 2007. There's also a step by step instruction on how to use Excel.

Microsoft Excel Connectors

By	Name	Data Access API	Supported Excel Versions	64 bit	Metadata support	Provider Notes	FAQ
Microsoft	Excel Source	Excel ISAM Driver	ALL
Interactive Edge	DataDefractor	Direct BIFF Read	ALL	yes	Worksheets, PivotTables		See website

Note: This article has been ported over from http://ssis.wik.is/ Note: If you were the owner of above article, please update it to the latest or with other appropriate information.