Hi everyone, I'm using an ASP script to open an xls spreadsheet and then output the data in a html table format. I've formatted ALL the cells in the spreadsheet to be in 'text' format, and yet when i use 'objRS.Fields.Item(X).Value' to return the value of the current cell, it only returns values where it matches the format of the rest of the cells in that column. I.e. if i had a table like:
Col1 | Col2 | Col3
1 X W
2 1 W
3 Y 1

It would return the following:
Col1 | Col2 | Col3
1 X W
2 W
3 Y

Like I said, I've formatted all the cells to be in 'text' format, so why is this happening?
You can see the file i'm working on at: http://www.durell.co.uk/Dan/ProductDetails.asp

HELP!!