Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from (filename) XLS ... gives garbage
Message
De
09/06/2006 18:34:28
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Append from (filename) XLS ... gives garbage
Divers
Thread ID:
01128230
Message ID:
01128230
Vues:
86
I'm attempting to import an Excel file. Since the columns tend to shift from time to time, I first create a cursor with wide character fields (so that I can hunt the columns containing the data I'm interested in), and then import the file using
Append from (filename) XLS
Today, however, I get garbage when I do this import -- very specific garbage. Each field for each record has two characters, the first being CHR(1) and the second the actual first character from the field being imported. (If the field was "Units", all I'll get is CHR(1) + "U")

Any ideas what's going on here?

TIA,
Jim Nelson
Newbury Park, CA
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform