Learn how to import data from Excel into your SharePoint lists via Access. Learn how to write append queries to load data into your tables.
- [Instructor] Using tools at its strength…is definitely a good option.…So adding data to SharePoint or Access depends on…how much data you're adding and how you need to add it.…Let's go ahead and add a list of clients.…I don't want to single type all of my customers,…I have them in an Excel spreadsheet.…So, let's go ahead and look at the customers list.…I could click new item for each one…or I could leverage the actionable queries inside of Access.…Let's go back to our database.…
I have a list of customers and they're stored…in an Excel file, so I'm going to go import that Excel file in…and then use a query to bring that…customer list into my customers table.…I'll go to External Data, I'll go to a New Data Source,…I'm going to bring it in from a file, I'll choose Excel.…I'm going to browse to my Exercise Files,…(computer mouse clicking)…and I'll choose my customer list.…
I'm going to import in this list and…then I'm going to append it to my customers list.…I'll go ahead and choose OK.…The first row does contain column headings,…
- Building an Access table and a SharePoint list
- Linking a SharePoint list to Access
- Exporting a table to SharePoint
- Connecting SharePoint to Access
- Creating macros to open lists
- Modifying Access forms
- Working with views
- Building reports for your integration
- Building views for data in SharePoint
- Sharing a SharePoint site with permissions
Skill Level Intermediate
SharePoint 2016: Branding SharePoint Siteswith Gini von Courter56m 10s Intermediate
SharePoint 2016: No-Code Workflowswith Gini von Courter1h 19m Intermediate
Access 2016: Reporting to Web Systemswith Adam Wilbert1h 47m Intermediate
1. Aligning Data between SharePoint and Access
2. Connecting SharePoint to Access
3. Building Forms for Your Integration
4. Building Reports for Your Integration
5. Building Views for Data in SharePoint
6. Generating Excel Reports for SharePoint
Linking data to Excel2m 26s
7. Finalizing the Database for Production
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.