Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2012, 12:40 PM
GST2212 GST2212 is offline Push data automatically from Acess or Excel to create a Gantt chart in Project Windows 7 64bit Push data automatically from Acess or Excel to create a Gantt chart in Project Office 2010 64bit
Novice
Push data automatically from Acess or Excel to create a Gantt chart in Project
 
Join Date: Jul 2012
Posts: 2
GST2212 is on a distinguished road
Exclamation 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!!
Reply With Quote
  #2  
Old 07-05-2012, 02:26 PM
JulieS JulieS is offline Push data automatically from Acess or Excel to create a Gantt chart in Project Windows 7 64bit Push data automatically from Acess or Excel to create a Gantt chart in Project Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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
Reply With Quote
  #3  
Old 07-06-2012, 12:42 PM
GST2212 GST2212 is offline Push data automatically from Acess or Excel to create a Gantt chart in Project Windows 7 64bit Push data automatically from Acess or Excel to create a Gantt chart in Project Office 2010 64bit
Novice
Push data automatically from Acess or Excel to create a Gantt chart in Project
 
Join Date: Jul 2012
Posts: 2
GST2212 is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 07-06-2012, 12:52 PM
JulieS JulieS is offline Push data automatically from Acess or Excel to create a Gantt chart in Project Windows 7 64bit Push data automatically from Acess or Excel to create a Gantt chart in Project Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
Reply

Tags
access, calendar, import

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Push data automatically from Acess or Excel to create a Gantt chart in Project 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
Push data automatically from Acess or Excel to create a Gantt chart in Project 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
Push data automatically from Acess or Excel to create a Gantt chart in Project Gantt Chart: MS Project vs. Excel Nance Project 2 12-09-2008 01:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft