O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required