Hi Molly,

Search over at http://www.ozgrid.com/forum for ado (ActiveX Data Objects) by XLDennis (Dennis Wallentin)

I believe all of his code samples are written to access Jet 4 database, but you should be able to easily change that for SQL

Post back if you need help

Best,

Winston