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:24:21
Vytautas Racas
Norway Registers Development
Kaunas, Lithuania
 
 
À
27/04/2001 05:05:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00500539
Message ID:
00500544
Vues:
31
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform