Home >Tips > SharePoint Online from Scratch > Update Imported SQL data kalmstrom.com site map icon Site map  

Update Imported SQL Data

A SharePoint Online tutorial by Peter Kalmström

SharePoint iconIn the previous demo Peter Kalmström, CEO and Systems Designer of kalmstrom.com Business Solutions, showed how to import data from an SQL Server database to SharePoint Online.

In the demo below Peter Kalmström shows how to keep imported data up to date.

Create a delete query

  1. Click on the Query Design button under the CREATE tab and select the SQL database table.

  2. Click on the Delete button in the ribbon to create a delete query.

  3. Save the query.

  4. Run the query to test that it removes the SQL Server data from the SharePoint list.

Create a macro that runs two queries in sequence

A macro is a way to automate a task that you perform repeatedly or on regular basis. It consists of a series of commands and actions that can be stored and run when you need to perform the task.
  1. 1. Click on the Macro button under the CREATE tab.

  2. 2. In the Action Catalogue, select the action ‘Open Query’ and the query that removes data.

  3. Select the action ‘Open Query’ again and now select the Add query to run.

  4. Select the action ‘Close the database’.

  5. Save the macro.

Add a Run button

  1. Click on the ‘Blank Form’ button under the CREATE tab.

  2. Click on the button icon and then in the form.

  3. Select the action Run Macro under Miscellaneous.

  4. Select the new macro you just created.

  5. Give the button a text and save the form.

  6. Click on Options under the FILE tab and select the new form as Display Form for the Current Database.

  7. To test, close Access and open it again. Then click on the button to run the query.

Learn more


Always the latest news in the kalmstrom.com blog

Follow kalmstrom.com on LinkedIn Facebook , Google+  or Twitter !

back icon next icon