Sherry,

(Note the use of < pre > and < /pre >, without spaces, to format code.)

Exactly what is FileName? Does it have the ".XLS" extention? Any spaces in the name or path? What happens if you use APPEND FROM ... TYPE XL5 or XL8?

After the APPEND command the result is an empty cursor, right?



>Cyndy:
> The following codes that I had been use for a long time. This month the user changed the format of the source from lotus file to xls file. I changed the file type to xls in append from command and the problem started.

>CREATE CURSOR import (batch N(5), handler N(3), inv_date D, ag_id C(6), ;
>	eff_date D, exp_date D, in_name C(35), pl_num C(13), cs_id N(3), ;
>	hist N(1), tran N(1), type C(5), commpd N(8,2), commrecd N(8,2), ;
>	period C(6), co_id N(3), UNUSED1 N(8,2), UNUSED2 N(8,2),UNUSED3 N(8,2),;
>	premium N(8,2), POL_FEE N(4),MISC_FEE N(8,2),TAX222 N(6,2), TAX555 N(6,2))
>
>SELECT Import
>APPEND FROM &FileName TYPE XLS

>
>I did check out the source file and it is not empty file. thanks.
>sherry