Hi Guys,

I am trying to load data from an xls file using an SQR into a custom table. The read command used in my sqr is returning some garbage values instead of the correct data.
The file that has to be loaded has a header followed by rows of data....The code looks like this
let #ctr = 1
while 1=1
read 1 into $recorddata:1000
let #ctr = #ctr +1
if (#end-file = 1)
!exit
break
end-if
if isblank(rtrim(ltrim($recorddata,' '),' '))
or substr($recorddata,1,6) = 'Emplid' or substr($recorddata,1,6) = 'EMPLID'
! do nothing
else
do processing
let #record_line_number = #record_line_number + 1
end-if
end-while

The $recorddata is containing garbage values when teh file is read using SQR...
Do you guys think there is some prbelm with the file being loaded...

Thanks,
Vamsi