Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting from excel or text files into memo field
Message
From
27/04/2001 05:24:21
Vytautas Racas
Norway Registers Development
Kaunas, Lithuania
 
 
To
27/04/2001 05:05:38
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00500539
Message ID:
00500544
Views:
34
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform