Bruce,
Correct me if I misunderstand you:
Your source DATAFILE is a txt or csv file, not Excel.
There is a single column of data in this source file.
You are using ADO to query this datafile.
The first entry in that column of the data file is numeric

What is the connection ?
What is the SQL you are using ?

NickHK

"brucelim80" wrote
in message ...

Hi
Can anyone help me with this problem? Thank

I have this Source excel with the data shown below;

DATAFILE
001
SVX
002
SFDAS
ERA123

I have written an interactive form in EXCEL VBA to let user to enter
the figure to search for based on the datafile.
When i use adodb connection and execute a statement to extract a
figure, it does not display the result as it only detect numeric
figure.

How do i resolve this problem ? i need the whole row to be string

Can anyone help me ?

Thank


--
brucelim80
------------------------------------------------------------------------
brucelim80's Profile:
http://www.excelforum.com/member.php...o&userid=32244
View this thread: http://www.excelforum.com/showthread...hreadid=520923