Solved

VBA code ot pull tasks into MS Project

Posted on 2011-09-15
4
506 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 19

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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Suggested Courses

622 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