How can I write an Excel plugin that loads a SQL Server data table?

My go开发者_StackOverflow社区al is to add a button on my custom excel ribbon that loads a data table the same way as if you click on Data->From Other Sources->From SQL Server.

The object model is so big, I'm having trouble finding the right path.

Thanks.

Have a look at the walkthrough examples from Microsoft:

For the Add-In itself

Walkthrough: Creating Your First Application-Level Add-in for Excel

For the custom Ribbon Tab

Walkthrough: Creating a Custom Tab by Using Ribbon XML

For deploying the Add-In

VSTO 2010 Deployment in Enterprise environment