Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from (filename) XLS ... gives garbage
Message
From
09/06/2006 18:34:28
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Append from (filename) XLS ... gives garbage
Miscellaneous
Thread ID:
01128230
Message ID:
01128230
Views:
80
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
Next
Reply
Map
View

Click here to load this message in the networking platform