Skip to content
ProjectControls.com
Open Plan Professional

Exporting/ importing OPP to Ms Access

In the Open Standard
James Anthony WoodMember for 22 years 8 months
Created
6
2
0
Greetings fellow Planners,

Question:- Is there an easy and simple way of exporting and importing data into and out of OPP from and to MS Access?

I want to keep it simple, so that I can show others how to do it without a long labourious process.

Cheers,

Jim Wood.

Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Radek Slanina ·
    #1
    OPP 3.1 stores data in MS ACCESS by default. The structure of data tables is described in developers guide. Maybe this can help...

    Radek
    Report
  2. 0
    Joanne Foster ·
    #2
    you can utilise either Cross Table Export, or write your own scripts in transfer.dat

    Once it is set up correctly, your users will just need to run the export script.

    Look at both the users guide and the developers guide for info on Exporting.

    Regards
    Joanne
    Report
  3. 0
    James Anthony Wood ·
    #3
    Hi All,

    Thank you Joanne for your reply, we will be upgrading to 3.1 soon, so hopefully this will have easier functionality than 2.6.

    Thanks again.

    Jim Wood.
    Report
  4. 0
    Joanne Foster ·
    #4
    oh...I didn’t realise that 2.6 was still out there - mind you I’m not sure if going to 3.1 is actually an upgrade or not!!!

    Anyway, 2.6 still has the transfer.dat functionality - so you can try that.

    Regards
    J
    Report
  5. 0
    John Owen ·
    #5
    OP 3.1b SP1 is available for download from SupportNet. This includes some updates to the standard OP 3.1 MS Project Import/Export feature (File; Import/Export; MS Project). This mechanism exports as much OP data as possible - which can sometimes confuse MS Project where feature support is different. If your need is to export OP projects to MS Project for reporting/contractual purposes then you could try the MSPRIF export (available by calling Welcom support) which modifies the exported data to coerce MS Project to display the exact same dates as Open Plan
    Report
  6. 0
    John Owen ·
    #6
    Oops, I saw Project rather than Access...

    OP 2.6 could save data directly into MS Access. You need an Access file populated with the relevant tables (from here: http://support.welcom.com/supportnet/tempdlfiles/OPP26_Access_2000.zip ) and an ODBC datasource pointing to the Access file. Once you have this use the ’File; Connect...’ option in OP 2.6 to connect to the database and restore your project (make sure you choose the ODBC data source in the file type when you restore each project file (Project, Calendar, Codes etc.). Be aware that the table structure is very different between OP 2.6 and 3.1 so don’t do any development if you plan on upgrading to 3.1 in the near future.
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?