I'm accessing an Excel spreadsheet using an ADO connection in VB6.

If the spreadsheet field contains just numbers the recordset returns a null.

Why?

The column is formatted to 'text'
If the cell is alphanumeric it's fine
if the number in the cell has an apostophe in front of it it's fine...


Thanks