Join Gini von Courter for an in-depth discussion in this video Creating a table from Excel data, part of Creating Access Web Apps in SharePoint 2013.
- Before we continue refining our Issues app,…I'd like to show you how we would…add tables if we wanted to create a table…from an existing data source.…We can create tables from data…that already exists in Access or Excel,…in SQL Server or other ODBC data,…as a CSV or text file, or data that lives…in a SharePoint list.…And regardless of the type we choose,…this data will actually be imported into our app.…We don't have the ability to link to this data.…It will always be imported.…And I'm gonna show you first how we would…bring in data from Excel.…
If you understand Excel, you'll understand Access.…If you understand Access, you'll understand SQL Server.…And if you understand Excel, you'll also understand…how to use a text or CSV import.…So those are very similar.…And then we'll look at SharePoint list,…which is a little bit different.…So I'm going to choose Excel…and I'm going to go find a data set that I have.…I have a spreadsheet that has products in it.…And if you have access to the Exercise Files,…you have this, too.…
AuthorGini von Courter
- Creating a new app
- Building tables from different sources
- Creating relationships between tables
- Working with views
- Using macros for automation
- Saving your app in an app package
Skill Level Intermediate
Relational Database Fundamentalswith Adam Wilbert2h 40m Beginner
SharePoint 2013 for Site Champions and Power Userswith Mark Abdelnour2h 58m Intermediate
1. Creating a Simple Access App
2. Working with Views
3. Automating and Packaging
Next steps1m 24s
- 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.