Office Link simplifies the task of importing live data into office applications and enterprise databases, such as Microsoft Excel, Access, SQL Server, Oracle and other ODBC databases.

Datasheet

Download

Purchase

Features

Link live data into spreadsheets and other applications capable of OLE Linking via a simple 'Copy & Paste' operation, linked data will update in the spreadsheet at a configurable rate. Reading and writing arbitrary OPC items via Excel Visual Basic macros is simplified down to a single function call, allowing Excel to fully control any OPC accessible device in the most effective way.

Sampling data is made just as easy. By default, Office Link creates an empty Microsoft Access database which can be used to gather samples for later analysis or continuously as live status reports. Use other ODBC databases such as Microsoft SQL Server, Oracle, text files, and also Microsoft Excel spreadsheets, in the same way. Office Link will sample into database tables and spreadsheets as configured, either continuously or controlled by a trigger.

Recipe transfers
Office Link supports data transfers from the database to the device ("recipe transfers"). Controlled by the device, data sets are looked-up and read from the database, then written back to the device via the OPC server.