Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro: Export selected data to SQL Server db

Status
Not open for further replies.

bloodyslover

Technical User
Jan 30, 2006
1
CA
Does anyone know how to write a Macro to export the user-selected data in a mpp file to a table in MS SQL Server db? Could this be implemented by Macro? If not, then what could implement this? a plug-in? No idea of how to write a plug-in for MS Project:(
 
Why not File | Save as ... and change the type to an Access DB and then import that into SQL Server?

(It will take too much time to explain to you just how non-trivial the table relationships are; do the above and then look at the table structures. The structures are fully described on the Project distribution CD ... can't remember the file names but they're a help file or a compile help file.)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top