That is not from database. Those data coming from an excel sheet.
I have an excel sheet and want to upload. But the excel sheet does not maintain any order. Following is sample data.
MONTHLY CLAIMS SUMMARY
For The Month Of : May Year: 2010
Staff Number : 552041
Dept/Location : Admin/Chennai
Monthly From...To… (mm/dd/yy) OVERTIME & STANDBY CLAIM TRAVEL CLAIM REIMBURSEMENT
Weekdays (RM13/hr) Saturday (RM13/hr) Sun & P.Holiday (RM17/hr) Standby (RM3.50/ hr) Mileage CAR (KM) Mileage Motorcycle (KM) Taxi (RM) Parking (meter) (RM) Parking (ticket) (RM) Toll (RM) Others (RM) Handphone (Postpaid) (RM) Handphone (Prepaid) (RM) Others (RM)
0.8 1.1 0.7 0.0 0.0 0.0 0.00
Amount (RM) 10.20 14.30 11.30 10.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Amount (RM) 46.00 0.00 0.00
Grand Total For The Month : 46.00
CHECKED BY :
PREPARED BY : (Team Leader), if any MGR'S APPROVAL:
SIGNATURE : NAME: NAME:
DATE: DATE: DATE:
First row contains the tile of the sheet and next row has name and value pair and so on. Please tell me how to upload one values to database and skip the names.
Thanks for your help.