MS Office 2007 files have a new format and therefore are not supported by the Jet 4.0 OLE DB provider. Specifically, the Office 2010 data source and data destination, which Buy Office 2010 connection manager based on JET, cannot be used with Microsoft Office 2007 Ultimate files. Microsoft Office 2007 Enterprise shipped with a new OLE DB provider, the Office 12 Microsoft Access Engine OLE DB Provider (aka ACE provider). The ACE provider must be used with Microsoft Office 2007 Professional and office 2007 professional plus files, but ACE supports only Microsoft Office 2007 data. SSIS has not been specifically tested with other data sources that are compatible with ACE, such as Microsoft SharePoint files, though it is possible to use them with Windows 7 ACE.
[ No Comments Allowed for Anonymous, please register | Parent ]
All logos and trademarks in this site are property of their
respective owner. Everything else is in the public domain.