Reading an excel file using ASP

[acerunner316]

dim xlsConn, xlsRS set xlsConn = Server.CreateObject("ADODB.connection") xlsConn.Open "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" & uploadsDirVar & "\" & fileName set xlsRS = Server.CreateObject("ADODB.recordset") xlsRS.open "SELECT SerNumber,IO2,ICO,IH2,I1,I2,KA,R FROM AddCalData", xlsConn xlsarr = xlsRS.GetRows() The problem is that the excel file has some fields that are optional. If the some of the fields in the first data line are empty, then the remaining data in that column is lost. All data are numbers. I think it has something to do with formatting. Maybe the drivers need data in the first column to determine datatype. I found somewhere that putting IMEX=1 in the connection string will make it not restrict datatype. I did not work. If the first column has all fields filled in, then the remaining data is fine. Please help. Thanks in advance!