Use the WHERE clause in the SQL.
For instance, assuming you have a column with a header of Name, you can use
sSQL = "SELECT * FROM [Sheet1$] WHERE Name = 'OverAC'"
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"OverAC" wrote in
message ...
I'm trying to access to a excel database without open it so I used ADO
in VBA from another excel file. That's why I want to know about ADO,
recordset..
I've just discovered a little about SQL but I think your explaination
will make clearer.
Thanks.
OverAC
--
OverAC
------------------------------------------------------------------------
OverAC's Profile:
http://www.excelforum.com/member.php...o&userid=32396
View this thread: http://www.excelforum.com/showthread...hreadid=521630