Get Time-Phased Data using SQL Scripts in MS ACCESS

J

Joe

MS provides the scripts to run against a Project Database
to retrieve data from the Time-Phased Table. The problem
is I am using a MS Access database, how can I run these
scripts in ACCESS. I tried to cut and paste it in the SQL
sections of Access, but that didn't work.

Joe
 
R

Rod Gill

Easiest way is to use Automation and the Timescalevalues method or for
Project 2002 onwards use OLEDB to read directly from .mpp files (2002
doesn't read daily values accurately but 2003 does).

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing Access MDB or Accdb with client using older or newer version of Office 1
Creating Network Diagram using a Chart SW integration 0
Time Phased / Work Remaining 7
REINSTALLING MS OFFICE PRO PLUS 2019 0
Time Phased Table 0
Office 2019 for mac, will it still…? 0
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
cube data and msp file data are not the same! 1

Top