Master SQL Server Express 2014: Create Databases Like a Pro

Microsoft SQL Server Express 2014 is a free, edition of SQL Server this is ideal for learning and developing desktop, web, and small server applications. The database size can be 10 gigabytes in size. SQL Server Express 2014 release includes the full version of SQL Server 2014 Management Studio. We will be using SQL Server … Read more

Installing SQL Server Express 2014

Microsoft SQL Server Express 2014 is a free, edition of SQL Server this is ideal for learning and developing desktop, web, and small server applications. The database size can be 10 gigabytes in size. SQL Server Express 2014 release includes the full version of SQL Server 2014 Management Studio. This is a method to read, … Read more

Turn Your PLC into a Data Goldmine with Modbus TCP Logging

Using Visual Basic 2015, we will log three holding registers from the PLC, along with the time and date, into a Microsoft Access Database. We will log every minute to the database, including the information we collect from the PLC via Modbus TCP (Ethernet). All code will be done and shown so you can implement … Read more

Build Your Own FREE PLC Training Lab with Real HMI Control

We will now create a PLC with HMI Training and learning environment. We will use the Automation Direct Do-More programming software tied into the Advanced HMI learning package via Modbus TCP. All of the software is free and fully functional. Learn PLC programming and use a powerful HMI (Human Machine Interface) easily and freely. Setting … Read more

Excel Secrets: Implementing Modbus TCP Protocol with VBA!

We are using Modbus TCP protocol, reading ten registers in the PLC, and displaying a bar graph in Excel. e will use Visual Basic for Applications (VBA) to communicate with a PLC. Previously we have used VB6 to communicate Modbus TCP. Sequence for Modbus TCP on Excel using VBA The following steps will be done: … Read more

Turn PLC Data into Excel Charts: Live Automation Insights

Utilizing the CX Server DDE Manager will allow us to provide a link to the information in the Omron PLC. This link can be placed on an Excel spreadsheet. Charts, graphs, etc., can be made from the data. We will create links on an excel spreadsheet from a CQM1H and a CP1L PLC. The information … Read more