Import command creates a dbf with a field of type charecter(254).
If in excel file clell content is longer, vfp cuts it.
I need full information.
Vytas
>I have a feeling you cannot append into memo fields in this way
>
>The other thing cou can try is
>Import from fieldname.xls type xls
>This will create a new table with the correct data type (it will be character in your case)
>You could then make this column a memo field.
>
>
>Import from filename.xls type xls
>Alter table dbf() alter column A M
>
>
>The import command makes up the column names a bit randomly - so don't reply on it being called A
>
>HTH
>
>
>>I created a dbf with one field of memo type.
>>Also an excel file with first column of long text.
>>
>>Run:
>>
>>APPEND FROM file.xls TYPE XLS
>>
>>Memo field is is empty.
>>I tried to change cell format from general to text - no difference.
>>
>>I've tried to append from text file - failed.
>>
>>How I should import into memo fields ?
>>
>>Any help appreciated.
>>
>>Vytautas Racas