Importing Microsoft Project data into Access 2016

Anonymous
2021-06-08T06:00:38+00:00

I've been importing Microsoft Project data into Excel but want to take advantage of the database features in Access. Therefore, I want to be able to do the following in Access 2016:

  • Browse for a Microsoft Project file
  • Open the Microsoft Project file
  • Import specific data from the Project file and save that data to a table

My questions are the following:

  1. What is the easiest way to browse for the Project file in VBA. FileDialog?
  2. I assume that I can open the file with the GetObject function (which I have done before).
  3. How do I commit the Project data to a table - via a recordset? (Note: It's been a LONG time since I've worked in Access.)

Any help would be greatly appreciated! Thanks in advance!

Microsoft 365 and Office | Project | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-06-08T11:21:00+00:00

    Regarding FileDialog, see https://www.devhut.net/2016/10/04/late-binding-the-filedialog/ for a late binding code sample so you don't need to set any references.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-06-08T09:40:40+00:00

    Hi J, I'm an independent adviser and will try to help.

    1. Yes FileDialog is the way to find the file. But that may not be the best way. Access will not, directly link to or import frpom MPP files. So the question is forst, whether you are transferring the data to Access or continuing to use Project. If you are continuing to use Project, your best bet, from what I can find, is a thrid party tool from cdata that allows you to create an ODBC DSN for the project data. If you are transferring from Project. you would probably be best off exporting from Project into an Access compatible format.
    2. GetObject uses Office Automation to control apps external to Access. I'm not familiar with Project VBA. so I'm not sure whether you automate exporting or even reading Project data that way. You might be better off importing into Excel And then importing into Access.
    3. Once you have a link to the data or imported it inot an Access table, you can then use APPEND queries to move the data into your Access tables.

    You might want to post this in a Project forum as well to see what options are available for exporting Project data.

    Was this answer helpful?

    0 comments