Specifying field types when connecting ADO to an Excel spreadsheet

Hi All,

I'm connecting to an excel spreadsheet via ADO with some rather interesting
problems. If I have a column in my spreadsheet that contains a combination
of numeric and alphanumeric data when the data is displayed in a TDBGrid
connected to the ADODataset some of the data is lost. At some point it seems
that the field type is being defined as either numeric or alphanumeric and
data not of the required type does not appear in the dataset.

Any ideas on what's going on here?

Paul Heyes