Install the SaveToDB add-in

You have to see the Database tab:

Install the SaveToDB add-in

Connect to your database table

Run Wizards, Connection Wizard:

Run Wizards, Connection Wizard

Select a provider:

Select a provider

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

Connect to your database

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

Select the required database object

Check fields to select and place filters to the ribbon:

Select fields

Select a target cell to insert a table:

Select a target cell

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

We recommend inserting into cell B3

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

You have an editable table

Edit and Save

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

Edit data and click Save
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.OK