Connecting to Databases with SaveToDB Add-in
Today we discuss how to connect to a database.
You will connect to a cloud Microsoft SQL Azure Database.
Please download and open in Microsoft Excel the following workbook
Open the Database tab, click Wizards, Connection Wizard.
You will see the dialog box like this:
The example workbook has configured connection parameters.
As a result, you see filled fields. Just click Next, Finish, and OK in every step.
You will get a connected table like this:
Try to edit data and click the Save button.
You can connect to your tables and views, edit data, and save the changes.
We have learned how to connect to a database and save changes back to a database.
In the next letters, we will discuss advanced features.
CEO | Gartle LLC