Microsoft Access 2013 Inside Out

Importing and linking data into web apps

You can certainly enter from scratch all the data into your empty tables in a new web app; however, in many cases, you’ll have some of the data you need already stored in other files or applications. For example, you might have an employee list in a spreadsheet or a text file, or your list of products might be in an Access desktop database. Access includes import wizards to help you bring the data into your new web app. You can import data into a web app that’s in text files, spreadsheets, other Access desktop databases, SharePoint lists, and any SQL database that supports the Open Database Connectivity (ODBC) software standard. You can also create read-only links to SharePoint lists inside the same SharePoint ...