![]() ![]() Note: The Author has experianced difficulty when importing Constraint Dates with this format. ![]() Box 4032 EASTWOOD HARRIS PTY LTD Tel 61 (0) Doncaster Heights ACN Fax 61 (0) Victoria 3109 Project Management Systems Australia Software and Solutions Web: USING P3 VERSION 3.1 IMPORT AND EXPORT FUNCTIONS WITH THE DBF FILE FORMAT AND EXCEL BY PAUL E HARRIS OF EASTWOOD HARRISÄ¢ TABLE OF CONTENTS 1 INTRODUCTION 3 2 SUMMARY OF THE PROCESS 3 3 CREATE THE EXPORT FILE LOCATION OF EXPORTED FILES CREATE AND A FEW ACTIVITIES IN P EXPORT THE DATA IN DBF FORMAT 4 4 CREATING THE DATA IN EXCEL OPEN THE EXPORTED DBF FILE IN EXCEL DELETE REDUNDANT DATA COLUMNS SAVE THE FILE IN EXCEL FORMAT POPULATE THE FIELDS WITH DATA ADD ANY NEW DATA ITEMS IN P EDIT THE NAMED RANGE DATABASE SAVING THE DATA 9 5 IMPORTING THE DATA BACKUP THE PROJECT FILE IMPORT THE DATA CHECK THE IMPORT LOG CHECK THE IMPORTED DATA 10 2Ä£ 1 INTRODUCTION P3 Export function will operate with four file formats: *.PRN ASCII *.DBF dbase III/IV *.WK1 Lotus 123 *.WSK Lotus 123 P3 Import function operates with three file formats: *.DBF dase III/IV *.WK1 Lotus 123 *.WSK Lotus 123 Whne Importing it is often easier to work with the DBF format which may be opened with Excel because: Header data is not imported as activities Only one area of the spread sheet has to have a named where as with Lotus Format each column of data has to be named. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |