Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel to recognize FoxPro memo fields?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00393509
Message ID:
00394535
Vues:
14
The quick and dirty way to export is to turn the memo into a character field with a select statement:

SELECT FLD1, FLD2, LEFT(FLDMEMO,250) AS MemFld INTO csrTest
COPY TO xlfile XL5

Note that you lose info if you have more than 250 characters in your memos (We dont).

Or, saving a few bytes:

CALC MAX(LEN(TRIM(fldMemo))) to lnMemLen
SELECT FLD1, FLD2, LEFT(FLDMEMO,lnMemLen) AS MemFld INTO csrTest
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform