EXCEL.IMP
                           EXCEL                
         IMPORTING INFO FROM EXCEL DISC INTO IMPACT
                                                  07/09/1995
 
GO INTO "WINDOWS" 

CHANGE TO "A" DRIVE ( WITH EXCEL INFO ON IT)

LOAD UP FILES WITH REFERENCE TO "500" OR "DIG" FILES

WHEN FILE HAS BEEN LOADED SAVE THE FILE AS A " *.CSV"

AMEND & ALTER THE ROWS/COLUMNS AS REQUIRED TO MATCH IMPACT

SAVE THE FILE AGAIN AS " *.CSV" & EXIT "WINDOWS"
 
GO INTO "IMPACT" & CREATE A NEW JOB & THEN EXIT BACK INTO "DOS"

GO INTO "FOXPRO"

SELECT "FILE" THEN "OPEN" FOLLOWED BY "IMPACT" & THEN "JOBS"

SELECT THE MIC NUMBER FOLLOWED BY THE FILE TYPE (500 OR DIG)

SELECT "DATABASE" (AT TOP OF SCREEN) FOLLOWED BY "APPEND FROM"

CLICK ON "DATABASE" & SCROLL DOWN UNTIL YOU FIND ...
"DELIMITED WITH COMMAS"

SELECT "FIELDS" & THEN DOUBLE CLICK ON MOUSE TO IMPORT REQD DATA

WHEN INFO HAS BEEN ENTERED PRESS "OK" DOUBLE CLICK ON "FROM"                    

& THEN "DRIVE" & SCROLL TO "A"

CLICK ONTO [ ] ALL FILES & SELECT "500 / DIG" .CSV

CLICK ONTO "ALL RECORDS" & "OK" RECORDS WILL IMPORT INTO FOXPRO.

CHECK THE INFO BY GOING INTO "DATABASE" & KEYING "BROWSE"

CLICK USING MOUSE ON LEFT HAND SIDE TO MARK WITH A DOT ALL CLEAR
& UNWANTED DATA. CLICK BACK ONTO "DATABASE" & KEY "PACK" FOLLOWED
BY THE "YES" PROMPT. GO BACK INTO "BROWSE" & CHECK THE DATA.

IF THE DATA IS OK THEN "QUIT" FOXPRO & GO INTO "IMPACT" AGAIN TO
COMPLETE THE REST OF THE JOB.