Skip to content
UdemyIT & SoftwarePaid courseIntermediate levelCertificate

How to Log Modbus Data to Microsoft Access and Excel (Udemy.com)

Set up the Winlog Lite HMI Development application to log data from a Modbus slave to Microsoft Access and Excel

Created by: Emile Ackbarali

Last updated May 2026

icon
What you will learn

  • Have an appreciation for the basic Structured Query Language commands
  • Build a Human Machine Interface to capture a Modbus data point
  • Configure a Human Machine Interface to log data to a Microsoft Access database
  • Configure a Human Machine Interface to log data to a Microsoft Excel file
  • Have an introductory appreciation for HMI scripting

How it compares

Against the other 1,182 rated Udemy courses in IT & Software on CourseDuck:

  • Rating4.6 out of 5higher than 67% of them
  • Reviews157#888 of 1,183 by number of reviews
  • Length1.2 hoursshorter than 94% of them
  • Last updatedMay 2026more recently than 75% of them

icon
Course Description

Archival of process control data is paramount to tracking of process performance and troubleshooting of issues with the process plant. Modbus is used heavily to acquire process data via the use of Human Machine Interfaces (HMIs). HMI's typically have the ability to not only read real-time data but also to archive that data for further analysis. A frequent drawback of HMIs is that archived data is usually stored in a proprietary format, which can make porting data to other system for further analysis problematic.

This course details the use of the Winlog Lite HMI in archiving process data directly to a Microsoft Access database as well as a Microsoft Excel workbook. By being able to do this type of archival, porting of data becomes much easier and faster. 

The course uses a Modbus slave simulator from which the HMI acquires a single data point which is deemed a line pressure. The HMI is then configured to have this data point archived every 10 seconds a Microsoft Access database as well as a Microsoft Excel file. Structured Query Language (SQL) is introduced to the student as well as an example of HMI scripting.

The course is very practical and the student can perform all tasks that are shown in the videos. In fact, throughout the course, students are strongly encouraged to do all that is show in the videos for maximum learning effect.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Emile Ackbarali

          I have been working in the fields of Software Development, Software Systems Integration and Process Automation since 1996. In 2003, I stepped out on my own and started working for myself providing software development and systems integration services to small and medium businesses.       

          Teaching has always been a passion for me. I have taught at the tertiary level for many years on the subjects of programming, control systems as well as systems integration. In the last few years I found myself incorporating more and more videos into the curriculum with amazing results. 

          When I heard of uDemy I just could not help but sign up. With teaching in a classroom, you can reach only so many students, but with uDemy you can reach the world! I plan to publish and promote as many courses as I possibly can on the uDemy platform. 

icon
More courses by Emile Ackbarali

$19.99

$10.99

$11.99

$11.99

$11.99

$11.99

icon
More IT & Software courses

$49.99

$10.99

$124.99

$19.99

$11.99

$19.99

icon
Reviews

4.6

157 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Hai Le on 11/28/2023

The course is well-structured and easy to follow. The instructor is very knowledgeable and explains the material in a clear and concise way. Thanks.

By Alan Michael on 1/12/2023

This course is exactly what I was looking for. Along with other Modbus courses it has equipped me to proceed on the adventure of automating Metrology Calibration and Verification tests and transferring the data to my Excel spreadsheets for analysis and certificate generation. Great stuff!

By Pete Olsen on 1/9/2020

Material is what I needed to know, however, I would prefer that you spoke a little slower.

By Marcelo Gonzalez on 11/18/2019

It uses a lot of software that are only trials; it's not giving me a complete aut-solution for my development

By Manish Shah on 7/11/2019

As usual, amazing tutor. IN depth knowledge. I am a big fan of him...Seems Very useful course Expecting some more courses related to automation & Iot (Azure)

By Saurav Kumar Jha on 1/21/2019

THIS IS WELL ORGANIZE AND VERY USEFUL FULL OF CONCEPTS AND AFTER TAKING THIS COURSE YOU CAN APPLY THESE THINGS VERY EASILY AND ONE SPECIAL THING ABOUT THIS COURSE IS YOU CAN NEVER FORGET THESE THINGS AFTER WATCHING ONE BY ONE EVERY LESSON AND APPLY IT IMMEDIATELY THANK U FOR THIS COURSE SIR.

By Eric Crispino on 1/7/2019

You will love this course if you're looking how to get/read data from your digital device capable to connect thru computer port.

By Kris Peshev on 4/21/2018

He was not explained for odbcad 32 , but here it is clear-http://cs.thomsonreuters.com/ua/fcs/cs_us_en/kb/how-to-create-an-odbc-connection-to-a-database.htm

By Phillip Donald on 2/19/2018

It's not the fault of the instructor, but I was unable to purchase a registered copy of Winlog Lite, a tool used in the course, because the vendor's online sales system was not working.

By Abdourahmane Diallo on 6/14/2017

So far I have have the feeling I'm learning something. He is articulate, and respond to your email if you have question.

Showing all 10 reviews on CourseDuck

Read all 157 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

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

Overall Score : 92 / 100