ebuabeng said:hi
I'm new to progress
and i would be very grateful if you can give me directions as to how i can
import data from excel to progress database using
either the data administration tool or using procedure editor.
thanks.
cecsno said:Hi,
Can you explain a little more about what you want to import to, is it a production database do you know what fields you want to populate and the order they appear in the Excel file?
"D0870" "MMA" 568754.5 01/01/04 12/31/9999
"D1323" "MMA" 451764.01 01/01/04 12/31/9999
"D0864" "MMA" 555983 01/01/04 12/31/9999
"d0490" "MMA" 517690.75 01/01/04 12/31/9999
"D1051" "MMA" 374623.26 01/01/04 12/31/9999
"D1345" "MMA" 568754.5 01/01/04 12/31/9999
"D1337" "MMA" 414517.5 01/01/04 12/31/9999
"D1332" "MMA" 406526.75 01/01/04 12/31/9999
"1358" "MMA" 454945.76 01/01/04 01/31/04
"1357" "MMA" 564504.75 01/01/04 01/31/04
"D0010" "MMA" 573026.5 12/01/03 12/31/9999
for each <tablename>:
delete <tablename>.
end.
for each <tablename> where <tablename>.startdate < 01/01/03:
delete <tablename>.
end.
Simon Sweetman said:If you get your data in a format like this the progress data admin should be able to load it (Admin->Load data and Definitions->Table contents (.d file).
It may ask some questions about code page, but just use accept the default.Code:"D0870" "MMA" 568754.5 01/01/04 12/31/9999 "D1323" "MMA" 451764.01 01/01/04 12/31/9999 "D0864" "MMA" 555983 01/01/04 12/31/9999 "d0490" "MMA" 517690.75 01/01/04 12/31/9999 "D1051" "MMA" 374623.26 01/01/04 12/31/9999 "D1345" "MMA" 568754.5 01/01/04 12/31/9999 "D1337" "MMA" 414517.5 01/01/04 12/31/9999 "D1332" "MMA" 406526.75 01/01/04 12/31/9999 "1358" "MMA" 454945.76 01/01/04 01/31/04 "1357" "MMA" 564504.75 01/01/04 01/31/04 "D0010" "MMA" 573026.5 12/01/03 12/31/9999
Note the load will not replace anything that is already there so you many need to delete all the records in the table first - from procedure editor type:
or example with data range specified (assuming you have a field called startdate in your table and want to delete everything before 01/01/03).Code:for each <tablename>: delete <tablename>. end.
Code:for each <tablename> where <tablename>.startdate < 01/01/03: delete <tablename>. end.
ebuabeng said:hi friends,
could you please , help me as to how i can add a new record to the tabe:
Ded_formula.
detail description of the table is as follows:
table name: Ded_formula
field names :employee#,start_date,end_date,ded_codes
thanks
..
I will welcome the syntax as well
hi friend,
could you please , help me as to how i can add a new record to the tabe:
Ded_formula.
thanks