Quote:
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.