This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access VBA: Automating Import of Excel Files
Section 1: Introduction
Introduction (4:31)
Section 2: Prepare Excel File and Create Import Tables
Record Steps to Prepare an Excel File for Import (8:50)
Create a New Database and Import an Excel File (6:18)
Fixing the Excel Import Problem (6:07)
Build the Import Work Table (5:39)
Section 3: Build the VBA Import Program
Create the Import Program and Start Adding Queries (10:31)
Add a Query to Remove Records Marked with Asterisks (8:09)
Test the Import Function and Update the Work Table (7:15)
ADDITION to Update Subroutine in Previous Lecture
Section 4: Add Error Capturing to the Import Program
Create a New Subroutine to Capture and Document Errors (9:48)
Finish the CreateErrStr Subroutine and Test the Program (10:03)
Correction to the CreateErrStr Subroutine
Section 5: Create and Post to the ROData Table
Create and Update the ROData Table (12:36)
Section 6: Using File Dialog to Select Files and Early and Late Binding
Create the SelectFile Program (12:04)
Introduction to Early and Late Binding (5:14)
Section 7: Create a Program to Prepare the Excel Import File
Link to Excel Reference Library and Take First Steps (9:55)
Use Excel Macro Steps to Prep Import File (7:09)
Import the Excel File and Do Final Testing (9:08)
Section 8: Final Changes - Use a Form to Call Our Import Program
Examine the Database and Forms (4:29)
Finish the Form by Adding a Button (9:18)
Section 9: Review and Conclusion
Review and Conclusion - What Have We Learned? (2:43)
Create a New Database and Import an Excel File
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock