[RESOLVED] The ADO, Excel and numbers mystery

[Guru]

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

[brucevde]

I remember someone else had the same problem but sorry I can't remember the exact cause. I think it had something to do with inconsistent data in the column, eg 1 cell has numeric data another cell has string data.

[Guru]

YES! YES! YES!

Thanks

I added 'inconsistent data' in my google search and found the solution!


Extended Properties="Excel=8.0;HDR=3DYes;IMEX=1;"