Assuming i have this mdb:
http://www.mytempdir.com/548579

and a sheet TEST where into A2 is:OI14006 is possible to use the table into mdb to return in B2: GERVASIO CRISTOFARO
IN effect i would want to use all in vba for excel.

Sub test()
Dim cn As Object, rs As Object
Dim myReturn As Long
Const dbfullname As String = "c:\DATA\user.mdb"

Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" _
& dbfullname & ";" 'Create DB connection

Set rs = CreateObject("ADODB.Recordset")
With rs

''''
peraps here the code for matching?

''''
If Not .EOF Then Let myReturn = .fields(0)
.Close: Set rs = Nothing
End With

cn.Close: Set cn = Nothing

End Sub

Cross-post JMT Forums.

And cross-post Access Programmers Forum

sal,

I haven't looked at the database sample.

However, if you have the connection and CommandText / SQL OK, what is the problem exactly?

cheers,
Fazza

Check the solution provided at JMT Forums (link in my post above)

Thanks shades. I'm not a registered user at the other site - hence can not access the solution posted.

Would appreciate if you could post the gist of the answer from the other forum.

If not, no worries. I won't lose any sleep over it.

regards,
Fazza