OleDB incorrectly returning DBNull for an Excel Column

[JohnMcA]

Hi,

I'm having problems accessing values in an Excel spreadsheet column which contain a ; delimiter. If there is only one value in the column, then it is correctly returned without any problem.

However, any other columns which also contain the ; delimiter work without problems, so I'm thinking that this has something to do with the spreadsheet column. For that reason, I setup a new column in the spreadsheet and copied & pasted some values over to it but the problem still remains. The cell format for the column is the same as the rest of the spreadsheet and I'm certain the values are there so no DB null value should be returned.

Has anyone seen this happen before? I spent a day going over my code and at this stage I'm nearly pulling my hair out with frustration. I'd appreciate any help or suggestions,

John