I want to add real-time SCADA signals, but I've got a problem. Due to strict security protocols of our company, I have no direct access to operational data. Although, I can generate reports ( .XLSX format), which are near real-time (considering the 10-15min hydraulic timesteps). I can see that, when I establish a SCADA signal connection to a .XLSX file, it is opened for good, so no external software can write that specific file until watercad is closed or scada signal is deleted. This behaviour prevents me to overwrite/update the .xls report that contains my signal data.
Do you know any workaround for this issue?
What I was thinking about (but not sure if it can resolve the issue):
- create an access database
- Link my excel sheet to the database
- establish scada connect to the access database file
The problem is: Referenced(linked) tables, such as XLS sheets are cannot be referenced through simple MS access database connection. Direct ODBC connection has some driver issues, which i couldn't resolve on my office PC (Win7 64bit, office 2010)...
But I have found an even more suitable workaround. It is kind of tricky, but It works flawlessly. The method is the following:
-Connection: Click Edit...
In Database Connection dialog:
-Choose: OLEDB Source as Data Source Type
-Click on the "..." button at Data Source field.
In Connection properties dialog:
-Click Change button at Data source
In Change Data source dialog:
Choose Microsoft Access Database File - Data provider: same .Net Framework Data Provider
In connection properties dialog:
-Database file name: Choose the .accdb you are about the use with the REFERENCED table.
-Leave other field as default
-Press OK (It shows ODBC connection, but there are no driver issues)
-Now you can select the referenced table from the Table name list and do everything like it would be a static table.
NOTE: You have to prepare your linked references to be refeshed automaticly as the following link shows:
I hope this is going to help someone someday.
Technical Development Engineer