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:05:38
 
 
To
27/04/2001 04:45:59
Vytautas Racas
Norway Registers Development
Kaunas, Lithuania
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00500539
Message ID:
00500543
Views:
26
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
Will Jones
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform