From the course: Access 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Importing tables
- [Instructor] If you already have information stored in a file such as an Excel workbook, then you don't need to retype to get it into Access. You can use the tools available to you on the External Data tab in order to pull that information in. You'll notice that we have lots of different file types that we can bring into Access underneath the New Data Source button. We can bring information in from an Excel file, or an HTML document, or an XML file. We can also bring it in from other Access databases, or from SQL server databases. So let's bring in an Excel file to replace the guests table that we began to create in the prior movie to this chapter. The Excel file that I'm gonna bring in has additional fields that we didn't create in the original, so adjust fields for the address. It also has details on about 200 guests, and I don't want to type all that information out manually. Instead of creating these fields, and then importing the data, we can create the entire structure of the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.