exporting project data to .mdb

[T]

Is it possible to export project data to .mdb using VBA?
I am using MSproject2007.

 

[Jack Dahlgren]

almost anything you can do manually, you can do with VBA. If exporting to
MDB is supported in your version of project, then record a macro of you
doing that to get the basic syntax.

-Jack

 

[Jan De Messemaeker]

..... but unfortunately 2007 no longer supports savibng as mdb :-((

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Richard L. Warren]

Worst case scenario: use the Texas Two-Step (i.e. Save As a Project 2003
..MPP file, then script Project 2003 to Save As the MDB file...;-)

=====
Richard Warren [MBA, PMP, MCITP for EPM]
http://richardlwarren.info


-----Original Message-----
From: Jan De Messemaeker [mailto:[email protected]]
Posted At: Monday, August 04, 2008 2:37 PM
Posted To: microsoft.public.project.developer
Conversation: exporting project data to .mdb
Subject: Re: exporting project data to .mdb

..... but unfortunately 2007 no longer supports savibng as mdb :-((

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Rod Gill]

Yes VBA can save to mdb file using VBA. I have done this for a client. As
the data was only being saved for multi-project reporting purposes, we
didn't use the standard Project 2003 database schema. Instead we only saved
data the client was interested in reporting on and the timescaled data was
in a format easy to export to Excel for pivot table creation (one record per
day for work and cost). The code runs fast enough not to be a problem. Code
to import from the same data is do-able.

Email me on rod.gill AT project-systems DOT co DOT nz if you are interested.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Worst case scenario: use the Texas Two-Step (i.e. Save As a Project 2003
.MPP file, then script Project 2003 to Save As the MDB file...;-)

=====
Richard Warren [MBA, PMP, MCITP for EPM]
http://richardlwarren.info


-----Original Message-----
From: Jan De Messemaeker [mailto:[email protected]]
Posted At: Monday, August 04, 2008 2:37 PM
Posted To: microsoft.public.project.developer
Conversation: exporting project data to .mdb
Subject: Re: exporting project data to .mdb

.... but unfortunately 2007 no longer supports savibng as mdb :-((

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

almost anything you can do manually, you can do with VBA. If exporting to
MDB is supported in your version of project, then record a macro of you
doing that to get the basic syntax.

-Jack

 

[T]

Thanlk you very much.
I will try learning from your Books.
--
beginnerMSP

Yes VBA can save to mdb file using VBA. I have done this for a client. As
the data was only being saved for multi-project reporting purposes, we
didn't use the standard Project 2003 database schema. Instead we only saved
data the client was interested in reporting on and the timescaled data was
in a format easy to export to Excel for pivot table creation (one record per
day for work and cost). The code runs fast enough not to be a problem. Code
to import from the same data is do-able.

Email me on rod.gill AT project-systems DOT co DOT nz if you are interested.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Worst case scenario: use the Texas Two-Step (i.e. Save As a Project 2003
.MPP file, then script Project 2003 to Save As the MDB file...;-)

=====
Richard Warren [MBA, PMP, MCITP for EPM]
http://richardlwarren.info


-----Original Message-----
From: Jan De Messemaeker [mailto:[email protected]]
Posted At: Monday, August 04, 2008 2:37 PM
Posted To: microsoft.public.project.developer
Conversation: exporting project data to .mdb
Subject: Re: exporting project data to .mdb

.... but unfortunately 2007 no longer supports savibng as mdb :-((

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

almost anything you can do manually, you can do with VBA. If exporting to
MDB is supported in your version of project, then record a macro of you
doing that to get the basic syntax.

-Jack


Is it possible to export project data to .mdb using VBA?
I am using MSproject2007.