Export from VFoxPro table to MS Project file ??

[zimmzimm]

I have a Visual FoxPro 8.0 application. I want to export VFP table (.DBF) data to a Microsoft Project (.MPP) file. How do I do this?

F.Z. - Boston MA

 

[DSummZZZ]

Forgive me for asking, but why in the world would you want to do something like that? There isn't anything in common between the two that I know of.



-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[craigsboyd]

Well there is no way to do it directly from what I can see since MS Proj doesn't support DBF files anymore. So you would probably have to import that data into Microsoft Access or one of the other Database backends that MS Proj supports and go from there.

Microsoft Project 2000 can read and write directly to the following file formats:

MPD/MDB files
Microsoft Excel 95 Workbooks
Microsoft Excel PivotTables® (export only, no import)
TXT files (Tab delimited)
CSV files (Comma delimited)
HTML files (export only, no import)

Some file formats that were previously supported and are no longer supported in Microsoft Project 2000 are:

Microsoft Project 3.0 files (MPP, MPV, MPC, MPW, and MPX)
Conversion of Microsoft Project 3.0 macros to current Visual Basic for Applications language and syntax (see Chapter 13, "Visual Basic for Applications" for information on making Microsoft Project 3.0 macros available in Microsoft Project 98)
FoxPro® DBF files
Lotus WKS, WK1, and WK3 files
dBase III and dBase IV DBF files
Excel 3.0 and 4.0 XLS files


Slighthaze = NULL
_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[rgbean]

Since I believe MS Project is an automation server, you could use VFP to read the data from the DBF and put it directly into a project file.

Rick

 

[zimmzimm]

Rick,

How do I deal w. automation server programmatically? Are there examples anywhere?

Best case would be VFPro to MS-Project, but any secondary application will do in lieu of this.

Fred Z.

 

[rgbean]

While I found references to doing this in "Microsoft Office Automation with Visual FoxPro" by Tamar Granor, Della Martin (

http://www.hentzenwerke.com/catalogpricelists/autofox.htm

), there isn't any code. I'd just start with the Project Object model, VFP with Intellisense (7.0 or 8.0) and the Object Browser and then "play".

Some MSDN articles that might help are:

http://msdn.microsoft.com/library/d...us/dnpom/html/pjtocobjectmodelapplication.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoffdev/html/msdn_projectvb.asp

http://msdn.microsoft.com/library/en-us/dnoffdev/html/msdn_ole2soln.asp

Rick

 

[baltman]

Check out this out too:

http://msdn.microsoft.com/office/understanding/project/devdocs/default.aspx

Brian