hi all,

any help to rename fields name as,

i have excel sheet with field names as
telno,customer_name,customer_number
,area,resiential

i need to append all data form myexcel sheet to my table alldata

CLOSE all
CREATE TABLE alldata( num n(9) ,service_type n(2),area n(2),Tel C(10) nocp,account_num c(15) nocp, customer_name C(80) nocp,flag n(2),n_try n(8)) 
***APPEND FROM d:\yosef\alldat TYPE xl5  &&it works take it as it is

**i need to replace field name and data as
append blank
replace tel with telno
replace area with area
replace customer_name with customer_name 
replace account_num with customer_number
replace num with 0
replace flag with 0
replace n_try with 0

thanks