Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel transfer
Message
De
28/05/2002 08:17:52
Denis Filer
University of Oxford
Royaume Uni
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Excel transfer
Divers
Thread ID:
00661940
Message ID:
00661940
Vues:
51
Importing data from Excel, I have some problems:

The prg attempts to sensibly rename the A B C etc Excel fields using a record selected by the user in the file i.e. with the field names. Follwing this, we often get:

1. Truncation of character fields
2. Strange behaviour of data in the DBF e.g. if you trim the data to remove leading spaces, it truncates to one character; inclusion of certain characters (Excel print features perhaps) that cause the data to disappear when selected. I am using the IMPORT FROM command type XL8.
Any comments appreciated ... Denis
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform