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

https://www.savetodb.com/downloads/example_of_connection_credentials.xlsx (10 KB)

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 may 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.

Best regards,

Sergey Vaselenko
CEO | Gartle Technology Corporation

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.