I'm using version 11, but I assume the syntax is similar for previous versions.
if oExcel is your Spreadsheet Control, then you can databind by setting the ConnectionString and CommandText of the ActiveSheet, like this:
oExcel.ActiveSheet.ConnectionString = ConnectionString;
oExcel.ActiveSheet.CommandText = "myStoredProcName";
If you aren't sure what to use as a ConnectionString, right-click on the control at design-time, choose commands and options, and run through the wizard to choose your data source (you can then delete the settings if you don't want there to be any default load).