I'm accessing an Excel spreadsheet in ASP using ADO. In one of its columns, I have a mixture of Numeric and Alhphanumeric values, but majority of them are Numeric values. The problem is that ADO sets the Data Type of that column as Numeric by-default and hence it ignores all the Alphanumeric values in other rows of the same column. I have also tried the MAXSCANROWS settings in Extended Properties of the Connection String by setting its value to 16, but still it sets the Data Type as Numeric for that column, whereas I need it to be set to Alphanumeric.
Please tell me some possible solutions to this problem.
Originally posted by Bullschmidt
This is going to sound stupid but it worked for me once at least with a CSV file (which of course can be read and written to by Excel). Make the first row contain some letters instead of just numbers.
I tried your solution by entering Alphanumeric characters in very first row of the respective column of the Excel sheet, but still it didn't work out for me. The data type which ADO sets for this column is still Numeric, so the rows having Alphanumeric values are ignored.