I have SQL and VB in school (only High School) and we learned how to get the connection and grab the data! We can also change stuff,... But it's not compiled in an excel worksheet!
Sorry but variables and comments and so are all in dutch! But it works fine! Needs running SQL Server and ODBC drivers! ;-)
Have fun!