Mohammed,
the index tag thing is something I missed to fix in your code:
if !seek(char9 ,'SomeAlias','char9 ')
if !seek(char9 ,'SomeAlias','char9')
If the mixed type of the excel column raises problems you can try to import the respective column to a char field and transform it by yourself to a field of the type of your needs.
You may use a "help" dbf for this import or simple change the type of your column and append a new column that will be used after the transform.
Agnes
>hi,
>thank you.
>but i have new error message,i have excel field as date(12-10-2004),som times with time,
>when i import this excel sheet to dbf,first i get a number as 6541,but i change myfield to date i get nothing ,
>
>now when i run your code i get error message (index tag is not found),becuse the field is empty.i think.
>
>any idea.
>
>thanks .
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]