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.
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?**
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 :
|Tags: access 2007, database, ms project, oracle|
|Thread Tools||Search this Thread|
|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|