I am trying to import data from MS Project Pro 2007 using this connection string: Provider=Microsoft.Project.OLEDB.12.0;Project Name=C:\Documents and Settings\Administrator\My Documents\test.mpp; I have also saved the project as Project 2000 -2003 and tried the above string with OLEDB.9.0(10.0 & 11.0) which all display the same error: Connection was not successful: The 'Microsoft.Project.OLEDB.12.0' provider is not registered on the local machine. I have searched for the web for hours on this and can't find an answer. Any help would be greatly appreciated.
This group is closing soon, so in future please use the programming group for this type of topic or the project.server group for project server. Project 2007 does not have oledb drivers any longer :-((. Apparently a download is available for the 2003 oledb driver but it only works with 2003 format files. -- Rod Gill Project MVP Project VBA Book, for details visit: http://www.projectvbabook.com NEW!! Web based VBA training course delivered by me. For details visit: http://projectservertraining.com/learning/index.aspx ---------------------------------------------------------------------------------------------------- "Mat_S" wrote in message news:3D542A92-CC9C-42EC-8727-D2EEC555AE11@microsoft.com... >I am trying to import data from MS Project Pro 2007 using this connection > string: > > Provider=Microsoft.Project.OLEDB.12.0;Project Name=C:\Documents and > Settings\Administrator\My Documents\test.mpp; > > I have also saved the project as Project 2000 -2003 and tried the above > string with OLEDB.9.0(10.0 & 11.0) which all display the same error: > > Connection was not successful: The 'Microsoft.Project.OLEDB.12.0' provider > is not registered on the local machine. > > I have searched for the web for hours on this and can't find an answer. > Any > help would be greatly appreciated.
