Linking Access 2007 to Microsoft Project 2007
in [Project]
|
From: JulieS on 21 Jan 2010 11:51 Hi Dale, As Rod Gill noted, unless you are using Access 2003 (which you aren't) you'll need to read and manipulate the data through code. JohnR posted a link to the information on MSDN about the data access model. I'll also put in a strong plug for investing Rod's excellent book on Project VBA. See: http://www.projectvbabook.com/ Julie On 1/21/2010 11:32 AM, Dale Fye wrote: > Guys, > > Appreciate your responses. I would really like to avoid having two separate > data sources (and the work required to keep them synchronized). Our > application is currently written in Access, using SharePoint lists as the > data source (long story). > > Given the comment that Project cannot read from Access unless the data is in > the right format, the question becomes, how can I use Access to > view/manipulate the data that is in a Project file? Or can I? > > If I can, then I could add/delete/change data in the Project file directly > from Access. This would obviously require some knowledge of the Project > Object model, but more importantly, a knowledge of the project data structure. > > ---- > Dale > > > > "Dale Fye" wrote: > >> >> I have an application that tracks various projects with milestones and other >> dates. My client is interested in visually depicting some of this >> information, and would like to try using Microsoft Project. >> >> They have created a small Project file with data they extracted and manually >> entered into project. What we now want to do is figure out how to either >> link Project to Access to use the Access tables directly, or to use Access to >> identify "differences" between their data and what exists in the application. >> >> Does anyone have any experience in this area? >> >> What is the format of a "Project" file. >> >> Anything I should know before I go blindly stumbling into this? >> >> ---- >> Dale >>
From: 0 on 5 Feb 2010 12:18 "Rod Gill" <rodATproject-systemsDOTcoDOTnz> schrieb im Newsbeitrag news:OIyGxlgmKHA.3476(a)TK2MSFTNGP06.phx.gbl... > Unless your Access database is structured exactly as Project needs it then > the only way to read data from any database in Project 2007 onwards is > using VBA code, either in Access to push data to Project or in Project to > pull data from Access. Project 2003 and earlier does have an ODBC link and > you can create a map to map fields in Access to fields in Project. This > does not link data, but does import to Project. > > -- > > Rod Gill > Microsoft MVP for Project - http://www.project-systems.co.nz > > Author of the only book on Project VBA, see: http://www.projectvbabook.com > > > > > "Dale Fye" <dale.fye(a)nospam.com> wrote in message > news:47F99EF6-4C01-490A-BCC1-CABD54F8D068(a)microsoft.com... >> >> I have an application that tracks various projects with milestones and >> other >> dates. My client is interested in visually depicting some of this >> information, and would like to try using Microsoft Project. >> >> They have created a small Project file with data they extracted and >> manually >> entered into project. What we now want to do is figure out how to either >> link Project to Access to use the Access tables directly, or to use >> Access to >> identify "differences" between their data and what exists in the >> application. >> >> Does anyone have any experience in this area? >> >> What is the format of a "Project" file. >> >> Anything I should know before I go blindly stumbling into this? >> >> ---- >> Dale >> >> >> __________ Information from ESET Smart Security, version of virus >> signature database 4791 (20100120) __________ >> >> The message was checked by ESET Smart Security. >> >> http://www.eset.com >> >> >> > > __________ Information from ESET Smart Security, version of virus > signature database 4791 (20100120) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > hallo >
First
|
Prev
|
Pages: 1 2 Prev: MS Project - Is this possible? Next: why is the options option greyed out? |