Excel 2013 :: Cannot Import Data Into ASP File

I am using Excel 2013, and I am following the example here: VBScript Scripting Techniques: Read Excel files without using Excel that reads in Excel data as an ADO record set to a classic ASP file using VBScript. I am not able to import all the Excel data successfully, and I need to know what I'm doing wrong. Note that in all these samples cell A1 is the heading text "Column1" and the main data starts on cell A2 (consistent with the example code).

When my source Excel data looks like the following:

Code:
Column1
1
2
3
4
5
6
7
X
9
10

It imports everything OK. However, if I move the X to the next row:

Code:
Column1
1
2
3
4
5
6
7
8
X
10
...the "X" cell gets imported as an empty string. So the imported array looks like this:

Code:
arrSheet[0][0]: Column1
arrSheet[1][0]: 1
arrSheet[2][0]: 2
arrSheet[3][0]: 3

[Code] ....

But if I add another X to an earlier row in the source worksheet, like so:

Code:
Column1
1
2
3
4
5
X
7
8
X
10
...this gets imported OK.