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 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