Import MS-Access 2007

[Digman]

I am trying to export tasks and assignments from an MS-Access 2007 Database
to MS-Project 2007. I have used VB code, but I am now trying to improve
performance. VB automation is a little slow (can take over 20 minutes to
complete).

Looking at the MS-Project 2007 options I thought I would try to use the
Import from MS-Access database. There is an option to import MS-Access 2003
version files (.mdb), but I can't figure out how to import .accdb file from
MS-Access 2007 (because I am using features only available in 2007).

Is it possible that MS-Project 2007 is incompatible with MS-Access 2007? I
find this hard to believe.

If I can't easily import from MS-Access 2007, what is the best way (keeping
in mind that speed is important).
Export from MS-Access2007 to .XML or .CSV? or maybe I should just link my
MS-Access 2007 to a new MS-Access 2003 database and use it?

Any suggestions?

 

[JulieS]

Hello Dave,

Sorry, Project 2007 will not natively read .accdb files. What features
specific to Access 2007 are you using? Have you experimented (on a
copy, of course) of saving the accdb file as an mdb file and attempting
the import?

If you haven't already, you may get some assistance in "fine tuning"
your existing code by posting to the microsoft.public.project.developer
newsgroup. You will need to post your code and perhaps one of the code
gurus there will weigh in. Additional information about how many tasks,
resources, and assignments you are attempting to import would also make
the speed (20 minutes) more meaningful.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Digman]

Julie

I am using the Access 2003 format, and so far no problem importing tasks.
Can't figure out how to import assignments yet. I have a question posted on
the developers board.

Thanks

 

[JulieS]

Hi Dave,

Are you running code for the import or just opening the mdb file in
Project? Do you get a different result if you try the importing in two
runs -- once with just the tasks and another with the assignment
information?

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Digman]

Julie

I wish I read your email sooner. I have been trying everything to use the
import function from MS-Project. I created an MS-Access 2003 dabase with 3
tables, Tasks, Resources, Assignments. I added a few tasks and a few
resources and then added assignments to link them together. I have tried
following the MS-Project wizard to import all 3 at the same time, but I just
kept getting weird results.

Finally I tried your suggestion. I imported each one separately. First I
imported the Tasks. Then I imported the Resources. And finally I imported
the Assignments. Finally it worked!

So - what gives ?

Is this a bug?

 

[JulieS]

Hi Dave,

Well, at least you finally found the method that works -- I'm sure you
wish you found it sooner

I wouldn't call the process a "bug" -- just a small quirk. In order to
create assignments, Project needs both resources and tasks. You may be
able to import both tasks and resources with one import, allowing
Project to create the unique IDs it needs for both. Then import the
assignments.

Julie
Project MVP