Install the SaveToDB add-in

You have to see the Database tab:

Connect to your database table

Run Wizards, Connection Wizard:

Select a provider:

Connect to your database on SQL Server, SQL Azure or another database server:

Select the required database object (table, view, function, or stored procedure):

Check fields to select and place filters to the ribbon:

Select a target cell to insert a table:

We recommend inserting into cell B3 (you will learn additional features later):

That's all. You have an editable table in Microsoft Excel:

Edit and Save

Now you may edit data in Excel. Click the Save button to save changes back to a database:

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.