Hi nick,
Thank you for your reply. I am using the following code as stated
below;



CONNECTION

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
With cn
..Provider = "Microsoft.Jet.OLEDB.4.0"
..ConnectionString = "Data Source=
C:\data\CustPv4ConcRiskCal.xls ;" & _
"Extended Properties=Excel 8.0;"
..Open
End With


SOURCE[/b]
MY SOURCE FILE IS ALSO ANOTHER EXCEL FILE

WHEN I PERFORM A MICROSOFT QUERY, IT ALSO EXTRACT ONLY THE NUMERIC
FIGURE FROM THE COLUMN, IT DOES NOT CAPTURE THE STRING.

EXAMPLE

MY DATASOURCE LOOK LIKE THIS FORMAT IN EXCEL;


DATAFIELD1 DATAFIELD2
AVD LONDON
GIA NEW YORK
223 HONG KONG
2223 SINGAPORE


SO I WROTE THIS SQL TO EXTRACT AS FOLLOW

SELECT * FROM `CUSTPV4CONCRISKCAL`.DATAFIELD1 WHERE DATAFIELD1 = AVD


IT WILL NOT SHOW THE RESULT.

[b]HOWEVER IF I EXTRACT BASED ON NUMERIC

Select * FROM `CustPv4ConcRiskCal`.datafield1 Where Datafield1 = 223


It will show the result. I observe that if there is a mixture of
datatype in a particular column, it will not work.


Can you help me with this?

Thank you


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