- When you're working with data…you certainly never want to retype…qualified or verified data.…Especially if you can import it…or link it into your new system.…This, of course, reduced error.…The only time we retouch data…is when it's absolutely necessary.…And you always want to do this in a mathematical way…so that you can always rerun with the same results.…This is critical for good reports.…The biggest benefit of importing…is that it allows you to bring in the data…but also allows you to control the design.…

Let's start by importing in one of our sample Excel files.…I'll go to the External Data tab.…I'll go to Excel.…I'm going to browse to my exercise files,…and I'm going to bring in my Original file.…Now, I want to bring in the list of department names.…So, I'll select DepartmentListNames.…Choose Next.…I've made sure that my first row…does contain column headings and that box is checked.…

If you were linking this file,…you wouldn't be presented this option.…Here, I can change the Field Name.…I can adjust the data type.…

Resume Transcript Auto-Scroll

Author

Released

9/15/2015

What happens when you combine Excel and Access? You get the best of both programs. Learn how to use Excel 2013 to get the most out of Access 2013 and save time building database solutions and running reports. Robin Hunt shows how to import and link to Excel data, run calculations in Excel and Access, build forms and reports in both programs, and automate tasks with macros, including the AutoExec startup macro in Access.