here is an ADO tutorial courtesy of si_the_geek.

It shows how to use SQL in ADO

http://www.vbforums.com/showthread.php?t=337051


HTH