Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memos to Excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00380879
Message ID:
00381339
Vues:
13
>I didn't find any quick fix. I tried variations of COPY TO using the old 2.x format and whatnot and had no luck. The only thing that worked was Automation.

Bingo! A little shuffling, and I've got it, a nice neat Excel sheet. Here is the sequence:

1) Access imports VFP data into Access DB, preserving memo length.
2) Access exports to Excel, again preserving memo length, and even placing all memo EOLs in the same Excel cell (so the text will show up properly formatted in that "tooltip" popup feature that Excel uses).

By golly, that's the first useful thing I've ever found for MS Access <s>
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform