When i dont want to include the ADO reference via "References" i use th
following code into excel vba module:

DIM CONN AS OBJECT
DIM REC AS OBJECT
SET CONN = CREATEOBJECT(\"ADODB.CONNECTION\")
SET REC = CREATEOBJECT(\"ADODB.RECORDSET\")

CONN.OPEN \"DRIVER......\"
REC.OPEN \"SELECT * FROM TABLE;\", CON

Regards,
Rafael Porche

--
locoloc
-----------------------------------------------------------------------
locoloco's Profile: http://www.excelforum.com/member.php...fo&userid=1551
View this thread: http://www.excelforum.com/showthread.php?threadid=26528