We have several groov EPIC units set up in our plant controlling various aspects of our equipment (e.g. feedrate, time, temperature).
20 years ago, we started using a Microsoft Access (.mdb) database to store each “recipe” (feedrate, time, temperature) of each part that we run. We are migrating this to SQL right now (still a few months away), and I know Node-red will offer us some nice connectivity options when that happens. But for now, all I want to do is query the Access database. I have searched this forum and others for how do to this, but the answers all seem either very complicated or require a special Windows only driver or something else.
Here’s where we have some flexibility…The small subset of data that we actually need from the database can be sent out once an hour as a .csv, for example, and place on shared network drive. It would be very simple, e.g.
Work order number, feedrate, time, temperature
76434, 350, 1:30, 1580
76435, 500, 2:05, 1650
76436, 400, 3:15, 1520
I could then set up our strategy to have the operator enter the work order number and then the 3 values (feedrate, time and temperature) would be pulled in and populated as variables.
What is the simplest way to accomplish this?