Linking MS Project to MS Excel - ODBC Connection

[FM1]

Me again. Fourth query in as many days. As you can tell Im not the
brightest spark when it comes to MS Project. Anywho, this time my query
relates to linking MS Project and MS Excel. I need to create a database
query within execl so I can update my excel sheet directly from a source
msp file.

Background story - currently have a massive programme plan. We also
have an excel sheet which contains an extract of all the milestones from
the programme plan. The excel sheet is updated on a weekly basis -
updates made on RAG status, milestone end date and % complete. We are
using a 'milestone code' to reference from excel to project. Because its
a manual process of checking each individual milestone in the programme
plan (140 milestones) its a long and tiresome process.

I was thinking that if we could automate this using an ODBC connection
so it updates the data automatically it would cut down an hours work to
the click of a button. So basically I was just wanting to know if that
is possible. If not, are there any other suggestions to update the
information automatically.

Thanks in advance.

P.S. I have attached a picture of a sample spreadsheet and project file
as a reference. Hopefully it should give people an idea of what they
look like and what Im trying to achieve.


+-------------------------------------------------------------------+
|Filename: MSE.JPG |
|Download: http://forums.techarena.in/attachment.php?attachmentid=7484|
+-------------------------------------------------------------------+

 

[Rod Gill]

Hi,

Read the pjoledb.htm file in one of Project's folders. It explains
everything. The driver is read only and is not available with project 2007.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[FM1]

Hi,

Read the pjoledb.htm file in one of Project's folders. It explains
everything. The driver is read only and is not available with projec
2007.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi Rod. I have had a look around but I wasnt able to find the document


Sorry to be a pest, but any chance you can post the link?

Thanks in advance

 

[JulieS]

Hi Rod. I have had a look around but I wasnt able to find the
document.


Sorry to be a pest, but any chance you can post the link?

Thanks in advance.


--
FM1
------------------------------------------------------------------------
FM1's Profile: http://forums.techarena.in/members/fm1.htm
View this thread:
http://forums.techarena.in/microsoft-project/1089184.htm

http://forums.techarena.in

FM1,

Search for the file on your local drive. It's included with a
standard Project installation. In my US English install for Project
2003, its in the 1033 folder in the Microsoft Office Program files
on c:\

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project