Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



compatability with Access or Oracle DB

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-11-2011
Member
 
Join Date: Nov 2011
Posts: 1
compatability with Access or Oracle DB

My boss has given my 1 day to find out which program to use - Access or MS Project.

Situation: We have a large Oracle based Database for work management which has no project management capabilities.

What needs to be done:**I will need to pull data from the DB and place it in a format that will allow me to do time, cost, productivity, and hrs per person per project type productivity.**It won't be a steady stream/connection.**I'll have to pull it bi weekly and insure that data gets updated.

My questions:
1) I know that MS Project can give me the analysts and reports, but I don't know if it can pull the data from an oracle based db

2) Can I do what MS Project does in Access?**I know about the 3rd party gantt chart software, but can Access float a custom basecalendar with exceptions on each person?

3) Or is there a way to pull the data with Access and then update the data in MS Project from Access?**

Reply With Quote
  #2  
Old 07-12-2011
Member
 
Join Date: May 2009
Posts: 523
Re: compatability with Access or Oracle DB

Oracle itself comes with a ability to import and export data. The objects which support the migration are :
  • Tables
  • Views
  • Indexes
  • Users
  • Constraints
Later on it is possible to import or export this data in another database system like Ms Access or Mc Project.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "compatability with Access or Oracle DB"
Thread Thread Starter Forum Replies Last Post
Compatability with Windows 7 Misraji Operating Systems 6 15-09-2010 12:31 AM
Motherboard compatability questions. apeksha1 Motherboard Processor & RAM 2 19-06-2010 12:51 AM
Where do i get Vista 64 Oracle ODBC driver for Microsoft Access 2007 B_Hodge Windows Software 3 01-06-2009 09:04 PM
Samsung pc3200+msi compatability Aberto Motherboard Processor & RAM 2 19-03-2009 03:01 PM
migrate an access database to oracle Sujit15 Software Development 5 25-02-2009 11:50 PM


All times are GMT +5.5. The time now is 05:17 PM.