|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Push data automatically from Acess or Excel to create a Gantt chart in Project
Hi Everyone
I am new to MS Project. I am trying to use project to create gantt charts of a process that has already occured. I have my data in Access and I want to plot it in Project. Project doesnt support data to be sent form acesss, so i m pushing it to excel and then importing it to project. Is there any way that i can automate this process and open project from Access? Also, how do I change the default calender in project to 24hrs as some of my operations are outside of the 8am-5m calender ? Any help on these topics would be greatly appreciated!! |
#2
|
|||
|
|||
Hello,
Re: Is there any way that i can automate this process and open project from Access? You may be able to automate the process through code -- the challenge is going to be ensuring the current data structure. You will likely still have to go through Excel. If you have some skills in VBA, I suggest posting your question to the Microsoft Forum for Project Programming at: http://social.technet.microsoft.com/...stprog/threads To your question of the 24 hours calendar, you should set that calendar as your project calendar through Project > Project Information. I hope this helps. Julie |
#3
|
|||
|
|||
Hi Julies
Thank you for your help. I change my calender for the project. But i need to create a new project file everytime someone runs my program. This messes up all the formating and calender |
#4
|
|||
|
|||
I'm guessing you are creating a new project file every time your "program" is run. Consider creating a template with the correct project calendar set and call to that template as the Project file is created.
|
Tags |
access, calendar, import |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create PPT slide presentation with Excel data. Chart is displayed off the slide. | eratem | PowerPoint | 4 | 02-29-2012 09:44 AM |
move to first date on gantt chart | etsoft | Project | 3 | 12-23-2011 08:32 AM |
How to create an Excel add in that will automatically build tables from data | selvamariappan | Excel Programming | 1 | 12-12-2011 03:11 AM |
Showing unscheduled tasks on Gantt chart | jaworski_m | Project | 0 | 11-20-2011 12:37 AM |
Gantt Chart: MS Project vs. Excel | Nance | Project | 2 | 12-09-2008 01:59 PM |