Udemyintermediateen

How to Log Modbus Data to Microsoft Access and Excel

Learn to log Modbus data from devices to Microsoft Access & Excel using Winlog Lite HMI. Simple data collection & reporting.

4.6(154)
815students
1h 10m
Certificate
Emile Ackbarali
Emile AckbaraliSoftware Developer, Systems Integrator and Entrepreneur

Course Content

How to Log Modbus Data to Microsoft Access and Excel is an intermediate-level Udemy course taught by Emile Ackbarali. It runs 1h 10m, is taught in English, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 154 reviews, with 815 students enrolled. It is a paid course, last updated June 2021.

Archiving process control data is crucial for monitoring plant performance and efficiently troubleshooting operational issues. Modbus is a widely used protocol for acquiring this data, often facilitated by Human Machine Interfaces (HMIs). HMIs commonly offer the ability to both view real-time data and archive it for later analysis. However, a common challenge is that HMI-archived data is frequently stored in proprietary formats, hindering data portability and analysis in other systems.

This course provides a practical solution: learn how to use the Winlog Lite HMI to directly archive process data to both Microsoft Access databases and Microsoft Excel workbooks. This method significantly simplifies and accelerates data porting for comprehensive analysis.

The course utilizes a Modbus slave simulator to generate a single data point – line pressure – which the HMI then archives every 10 seconds. You'll gain hands-on experience configuring the HMI for data archiving to both a Microsoft Access database and a Microsoft Excel file. We'll introduce you to Structured Query Language (SQL) and demonstrate practical HMI scripting examples.

This is a highly practical course; you'll be encouraged to follow along with all demonstrations to maximize your learning. You'll gain the skills to perform all tasks shown in the video tutorials, enabling you to effectively manage and analyze your process data. Learn to easily export your data for further analysis and reporting.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(178)
1h 34m
intermediate
skillshare
5.0(458)
43m
beginner
skillshare
5.0(279)
2h 6m
beginner
skillshare
skillshare