Microsoft Project ODBC Use

[Ash]

I have some planning data in my Database (Oracle), I need to pull that data
out into Microsoft Project using ODBC and automatically populate a *.mpp file
.. Please suggest what would be a good approach to do that, writing a VBA code
or what.

thanks,
Ash

 

[Earl Lewis]

Ash,

First thing you need to do is figure out what kind of data you have and decide where it's gotta end up in your project plans. This is probably the most difficult part of the task ahead of you.

In all likelihood, unless you have very specific project information (tasks, assignments, start and end dates) you will probably be putting this into MSProject custom fields. If you're using .mpp files instead of project server you'll be using standard custom fields as opposed to enterprise custom fields that are used in project server.

Once you've decided where specific data will go you can write some VBA code to open your source data and update your project plan fields appropriately. Here's some psuedo-code to show you the idea.

Sub InsertExternalData()

ConnectToOracleDSNviaODBC
CreateRecordsetViaConnection
OpenYourDesiredMPP
UpdateMPPFromRecordset
SaveMPP
CloseRecordsetAndConnection

End Sub

I'd suggest looking into the SetField method help in MSProject to find out more about the details of updating specific fields and values.

Hope that helps get you started.

Earl
I have some planning data in my Database (Oracle), I need to pull that data
out into Microsoft Project using ODBC and automatically populate a *.mpp file
.. Please suggest what would be a good approach to do that, writing a VBA code
or what.

thanks,
Ash

 

[amit]

Hi Earl,

I have the same problem.

Can you gife an sample off a macro code, how to import a project.
The project has a taskname, start and a enddate.

regards,

Amit

 

[Carole]

Hello

I want to do this do you have a sample of code ???