View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Basic ADO medthod - working with recordset, plz help.

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