export ms project data to oracle using vba

[Polina]

Hello,

I'd like to export data from MS Project to Oracle. There is an option
using "Save as" and ODBC but I wonder if my problem could be solved
using VBA.

Thank you!

 

[Rod Gill]

Hi,

Much the simplest way is to create a DSN and save using DSN unless you only
want part of the data saved.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Polina]

Hi Rod,
thank you for your answer!
I've already created a DSN and it works well. But my idea was to start
a particular export scheme from vba (or as a makro). Do you know if it
is possible?

Polina

 

[Polina]

OK, I found something.
The vba code is:

FileSaveAs Name:="<DSN_NAME>", UserID:="YourUserID",
DatabasePassWord:="YourPWD", FormatID:="MSProject.ODBC",
map:="YourExportScheme"

Thanks anyway!