Ok here is my problem, when importing data from excel using ADO, delphi doesn't seem to be able to import mixed column values...e.g. the column is formatted to integer and the integer values correctly import into delphi, but the same column contains string values it imports nothing or null.
It doesnt help changing the format either, I do not know why. So how do i get delphi to import multi values cells?
any help welcome!