Import MS-Access 2007
in [Project]
|
Prev: Gantt Chart resource initials
Next: XPS disply problem
From: Digman on 14 Jan 2010 07:47 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? -- Dave
From: JulieS on 14 Jan 2010 09:16 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 On 1/14/2010 7:47 AM, Digman wrote: > 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? > > > >
From: Digman on 14 Jan 2010 10:02 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 -- Dave "JulieS" wrote: > 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 > > > On 1/14/2010 7:47 AM, Digman wrote: > > 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? > > > > > > > > > . >
From: JulieS on 14 Jan 2010 11:55 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 On 1/14/2010 10:02 AM, Digman wrote: > 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 >
From: Digman on 14 Jan 2010 21:59
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? -- Dave "JulieS" wrote: > 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 > > > On 1/14/2010 10:02 AM, Digman wrote: > > 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 > > > . > |