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