Solved

VBA code ot pull tasks into MS Project

Posted on 2011-09-15
4
488 Views
Last Modified: 2013-11-15
I need to pull data from a sql view into task of a MS Project 2007 andd/or 2010. The data changes in sql through data collection and we need this to update our schedule in ms project. We do not want to invest in MS Project Server. I am fine with running the code once we have opened the project.  I have all the columns in the view in the same order as we have the task set up in project.
When I found out I could not save the ODBC connection in a user friendly way i exported the data from sql to excel and then linked it to the project but this is still not user friendly.

0
Comment
Question by:jclippert
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
Richard Daneke earned 500 total points
ID: 36545755
Project is an Access database.   Maybe an Access routine that connects to your SQL and Project will serve you.   The Project connection should be available when you include the Project libraries in the VBA.
0
 
LVL 18

Expert Comment

by:xtermie
ID: 37182839
You can check here for alternaties:
(1) http://msdn.microsoft.com/en-us/library/ms436148(v=office.12).aspx
also you may want to download the Project ODBS from here
http://microsoft-project-odbc.fyxm.net/
0
 
LVL 18

Expert Comment

by:xtermie
ID: 37200732
Any luck with those?
0
 

Author Comment

by:jclippert
ID: 37223424
We went another direction that eliminated the problem for now.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question