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.

Follow kalmstrom.com on LinkedInFacebook or Twitter!

back icon next icon
Products Buy FAQ Services Tips Services Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved