Problem: I'm trying to find a way to save the contents of a Microsoft Project 2007 file with all project information (schedule, resources, assignments, etc.) into Microsoft Access 2007, and then back into Project, while preserving the full fidelity of all the data. One method I tried: Save Project data as XML. Import XML into Access. Does not work because the hierarchy of the XML data is lost in the process, and I cannot export out the same XML that I originally imported.Second method I tried: Save Project data as Excel Project format (.xls). However, loading the .xls back into Project yields different schedule information than the original. Appears this is a buggy feature by Microsoft.This seems like an unexplored area, many web searches turned up nothing. Any advice?
Microsoft Project 2007 to/from Microsoft Access 2007
- Thread starter Provac
- Start date