Microsoft Access VBA: Automating Import of Excel Files (Udemy.com)

Learn how to completely automate the periodic import of Excel files!

Created by: Bruce Myron

Produced in 2021

icon
What you will learn

  • Perform several advanced Microsoft Access techniques that will enable them to create more robust database systems

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 96 / 100

icon
Course Description

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 automatically 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 theOffice 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 createsa reportshowing 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 toperiodically importExcel files!
This course is "hands on" and we completelybuild the databasestep by step in the course lectures. The course is built so that you can watch the steps then pause the lecture anddothem yourself!
There is aHUGE need in the marketplacefor people whoREALLYknowhow to doMicrosoft Access projects like this one. This is your opportunity tobreak away from the packof 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 andand learn how to use AccessMUCHmore effectively than just about anyone else!__________________________________________________________________________In addition to theUdemy30-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 medirectly and Iwill do mybest to get back to you as soon as possible!__________________________________________________________________________What I am NOTable to do for youin this Course..
I can't guarantee your success learning the concepts inthis course and then applying them WILLtake work on your part. But You Can Do It! ANDit 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 forMicrosoft Access VBA!
See you in the course!
Sincerely,Bruce MyronWho this course is for:
A person who has some exposure to Microsoft Access VBA, but wants to learn more advanced methods.

icon
Instructor Details

Bruce Myron

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.

icon
Reviews

4.8

112 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Johan Welman on 11/15/2020

Very good and relevant information, very well presented.

By Athanasios Litsakos on 11/8/2020

Gee, Sometimes you have to think out of the box

By Kristopher Powell on 10/16/2020

Wonderful teacher!

By Robin Weesner on 10/1/2020

Makes total sense to start out this way with recording macros.

By Janel Lee on 8/7/2020

Suggestions - 1. Use excel sheet to update existing records and create new records 2. Validate fields that refer to another table (ensure that it does not violate referential integrity)

By William Armstrong on 8/6/2020

Easy to follow and instructions work

By Idlir Bekteshi on 7/25/2020

Very good match. I achieved my goal

By Charles Davidson on 7/18/2020

Absolutely. Bruce is a fantastic teacher

By Amed Mesa on 7/6/2020

I'm using this skill on a multi-billion dollar contracts to process bulk information. The skills in this course open the door for data science in the typical office. Appreciate the knowledge share.

By Mandy Feingers on 6/19/2020

Excellent!

By Keith MacLyman on 6/5/2020

This course was very relevant to my current project. Very helpful

By Praveen Desai on 5/8/2020

Above expectations very useful