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