Read .dat file record as follows;
Note Intime means I
Outtime Means O
Oracle Design Structure as follows;
Emp_No Year Month Date time In/Out
In run mode screen as follows;
Browse Button and submit button.
when i click the Browse Button read the .dat file from the system and i have one button called submit.when i click the submit button that read the .dat file and save it into the oracle data base.
Design in Asp.net and back end Oracle11g
Oracle Data base output as follows;
Emp_No Year Month Date time In/Out (from read .dat file)
000001 2013 01 01 10000 I
Thanks and regards,