Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting from excel or text files into memo field
Message
De
27/04/2001 05:05:38
 
 
À
27/04/2001 04:45:59
Vytautas Racas
Norway Registers Development
Kaunas, Lithuania
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00500539
Message ID:
00500543
Vues:
33
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform