Re: ADO XLS

"Allan Fernandes" <tech@xxxxxxxxxxx> wrote in news:4810838c$1
@newsgroups.borland.com:

Hi,

My XLS file has values thus for the Field Gender

Gender
1
2
1
2
Male
2
Female
1
2

How can I read them all ? because Male/Female come blank.
Regards
Allan

See http://support.microsoft.com/kb/257819 - the section headed "A Caution
about Mixed Data Types"
.