Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from (filename) XLS ... gives garbage
Message
From
09/06/2006 19:11:34
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01128230
Message ID:
01128235
Views:
26
Sergey --

Same results with both XL5 and XL8.

Thanks anyway


>>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")
>>
>
>Jim,
>
>I dunno what the problem is but you can try with XL8 or XL5
Jim Nelson
Newbury Park, CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform