Microsoft Access VBA: Automating Import of Excel Files
4.8 (36 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,296 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access VBA: Automating Import of Excel Files to your Wishlist.

Add to Wishlist

Microsoft Access VBA: Automating Import of Excel Files

Learn how to completely automate the periodic import of Excel files!
4.8 (36 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,296 students enrolled
Last updated 8/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 5 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Perform several advanced Microsoft Access techniques that will enable them to create more robust database systems
View Curriculum
Requirements
  • Students should understand the basics of Access and have had some exposure to VBA.
Description

NOTE: The last section, where we create a button on a form and then link our import program to it, will be added on Saturday Morning, July 22.

Many students have contacted me with requests on how to handle the periodic import of Excel files.  Typically an Excel file is received weekly or monthly and needs to be imported and used to update and/or add to a main data table.  This course will show you how to reduce this process to nothing more than selecting the import file.  The rest of the steps are handled automatcially in seconds! 

Even if you never need to import Excel files, there are several VBA techniques in this course that have not been covered in any of my other courses!  Topics like using the Immediate Window, using the Office File Dialog box to select files and how to use "Late Binding" to make sure your VBA code works with any version of Access! 

The program we will build together doesn't only import the Excel file, it also analyzes the data for errors and creates a report showing the details of what needs to be corrected!  If you are willing to take the time to go through this course you could completely eliminate the headache of having to periodically import Excel files!

This course is "hands on" and we completely build the database step by step in the course lectures.  The course is built so that you can watch the steps then pause the lecture and do them yourself!

There is a HUGE need in the marketplace for people who REALLY know how to do Microsoft Access projects like this one.  This is your opportunity to break away from the pack of people who struggle to create effective systems and demonstrate that you have the skill to save huge amounts of time!  Stop being like everyone else and and learn how to use Access MUCH more effectively than just about anyone else!

__________________________________________________________________________

In addition to the Udemy 30-day money back guarantee, you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message me directly and I will do my best to get back to you as soon as possible!

__________________________________________________________________________

What I am NOT able to do for you in this Course..

I can't guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It!  AND it will be well worth it!

________________________________________________________________________

This course will not remain this price forever! It's time to take action!

Click the "Take This Course" button at the top right now!

...every hour you delay is costing you money...you could become the goto person for Microsoft Access VBA!

See you in the course!

Sincerely,

Bruce Myron 


Who is the target audience?
  • A person who has some exposure to Microsoft Access VBA, but wants to learn more advanced methods.
Compare to Other Microsoft Access Courses
Curriculum For This Course
24 Lectures
02:32:23
+
Introduction
1 Lecture 04:31
+
Prepare Excel File and Create Import Tables
6 Lectures 27:19
Download Excel Files for Import
00:06


NOTE: Update to Access 2016 Import Menu
00:18

Create a New Database and Import an Excel File
06:18

Fixing the Excel Import Problem
06:07

Build the Import Work Table
05:39

Here are questions related to the steps we took to prepare the Excel file for importing.

Prepare the Excel File Quiz
4 questions
+
Build the VBA Import Program
4 Lectures 27:37
Create the Import Program and Start Adding Queries
10:31

Add a Query to Remove Records Marked with Asterisks
08:09

Test the Import Function and Update the Work Table
07:15

ADDITION to Update Subroutine in Previous Lecture
01:42

Review the previous lectures where we created our Access database and imported the Excel file.

Create Database and Import Excel File Quiz
3 questions
+
Add Error Capturing to the Import Program
3 Lectures 20:36
Create a New Subroutine to Capture and Document Errors
09:48

Finish the CreateErrStr Subroutine and Test the Program
10:03

Correction to the CreateErrStr Subroutine
00:45

Review the steps we took to capture errors during import.

Add Error Capturing Quiz
3 questions
+
Create and Post to the ROData Table
1 Lecture 12:36
Create and Update the ROData Table
12:36

Review what we learned in the Create ROData section.

Create and Update the ROData Table Quiz
2 questions
+
Using File Dialog to Select Files and Early and Late Binding
2 Lectures 17:18
Create the SelectFile Program
12:04

Introduction to Early and Late Binding
05:14

Review what we covered in the File Dialog and Binding Section.

File Dialog and Early and Late Binding Quiz
5 questions
+
Create a Program to Prepare the Excel Import File
3 Lectures 26:12
Link to Excel Reference Library and Take First Steps
09:55

Use Excel Macro Steps to Prep Import File
07:09

Import the Excel File and Do Final Testing
09:08

Review what we learned in the section on creating a program to prepare the Excel file.

Prepare the Excel Import File Quiz
2 questions
+
Final Changes - Use a Form to Call Our Import Program
3 Lectures 13:51
Link for Downloading the ROTrackingDONE Database
00:04

Examine the Database and Forms
04:29

Finish the Form by Adding a Button
09:18
+
Review and Conclusion
1 Lecture 02:43
Review and Conclusion - What Have We Learned?
02:43
About the Instructor
Bruce Myron
4.6 Average rating
4,628 Reviews
46,493 Students
15 Courses
Productivity Specialist

Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business.

"Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce

I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do.

I have also spent time as a full time trainer providing group classes on the Microsoft Office programs.

In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible.

Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed.

My goal is to show my students how to create systems that business will value and that will create long term income.

Billy Myron
4.7 Average rating
2,112 Reviews
16,064 Students
12 Courses
Udemy Instructor

Hello, my name is Billy. I was born and raised in the state of Oregon, and still live there.

On Udemy, I primarily assist Bruce Myron as an instructor on his courses. They deal with Microsoft Access, Microsoft Access VBA, and other Microsoft Office programs such as Excel.