Introduction
  • Introduction
  • Important NOTE on DOWNLOADABLE RESOURCES
Prepare Excel File and Create Import Tables
  • Record Steps to Prepare an Excel File for Import
  • NOTE: Update to Access 2016 Import Menu
  • Create a New Database and Import an Excel File
  • Fixing the Excel Import Problem
  • Build the Import Work Table
  • Prepare the Excel File Quiz
Build the VBA Import Program
  • Create the Import Program and Start Adding Queries
  • Add a Query to Remove Records Marked with Asterisks
  • Test the Import Function and Update the Work Table
  • ADDITION to Update Subroutine in Previous Lecture
  • Create Database and Import Excel File Quiz
Add Error Capturing to the Import Program
  • Create a New Subroutine to Capture and Document Errors
  • Finish the CreateErrStr Subroutine and Test the Program
  • Correction to the CreateErrStr Subroutine
  • Add Error Capturing Quiz
Create and Post to the ROData Table
  • Create and Update the ROData Table
  • Create and Update the ROData Table Quiz
Using File Dialog to Select Files and Early and Late Binding
  • Create the SelectFile Program
  • Introduction to Early and Late Binding
  • File Dialog and Early and Late Binding Quiz
Create a Program to Prepare the Excel Import File
  • Link to Excel Reference Library and Take First Steps
  • Use Excel Macro Steps to Prep Import File
  • Import the Excel File and Do Final Testing
  • Prepare the Excel Import File Quiz
Final Changes - Use a Form to Call Our Import Program
  • Examine the Database and Forms
  • Finish the Form by Adding a Button
Review and Conclusion
  • Review and Conclusion - What Have We Learned?
  • BONUS Lecture! Learn Even More!