Import .xls into ASP

[electroBOYY]

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!!

[mendhak]

Let's see your code. Also, I know you can't post the XLS file here as it's company data, but can you post a sample XLS?

Try to create a sample page to work with the sample data to narrow down your issue.

[electroBOYY]

Hey mendhak.
I've intergrated the code into the main site now, so it will be hard to extract the code for creating the html table.
I'm just going to leave it as it as.
Thanks for the reply.