M
Michael Gooding
I've been working on some coursework that requires the use of an excel
spreadsheet and a CSV file to be read into an ASP page and worked
with.
What I have done is set up an array to store the values from the CSV
file and accessed the spreadsheet using an Excel Recordset.
For some reason only the first 2 values in the CSV file (stored in the
array as the first and last) are comparing properly with values from
the spreadsheet.
When the comparisons are made I have used a loop to go through all the
records in the recordset and then another loop to search the array.
If I hard code the values instead of the array values the results are
as expected.
I've tried making sure all the values are trimmed and preceeded with
the "cstr" operation and still no joy. Even when I've written the
comparisons to screen it is saying "RGD11 = RGD11 = False"
Has any one got any clues as to what is going on???
spreadsheet and a CSV file to be read into an ASP page and worked
with.
What I have done is set up an array to store the values from the CSV
file and accessed the spreadsheet using an Excel Recordset.
For some reason only the first 2 values in the CSV file (stored in the
array as the first and last) are comparing properly with values from
the spreadsheet.
When the comparisons are made I have used a loop to go through all the
records in the recordset and then another loop to search the array.
If I hard code the values instead of the array values the results are
as expected.
I've tried making sure all the values are trimmed and preceeded with
the "cstr" operation and still no joy. Even when I've written the
comparisons to screen it is saying "RGD11 = RGD11 = False"
Has any one got any clues as to what is going on???