Trends - Frequently Asked Questions
- Last UpdatedJul 18, 2023
- 2 minute read
Q: How do I get trend data into a dBASE database?
A: Display the trend on screen and select the File Save/As tool. This tool displays a Save/As dialog box for you to enter the name of the file, and calls the TrnExportDBF function to save the data. (For more complex procedures, call this function directly.)
Q: How do I get trend data into Excel?
A: You can get data into Excel in three ways:
-
Display the trend on the screen, select the Clipboard tool to copy the data, and use the Excel paste command to paste the data into Excel.
-
Display the trend on the screen and select the File Save/As tool. Save the data in CSV format, and open the CSV file in Excel.
-
Display the trend on the screen and select the File Save/As tool. Save the data in DBF format and open the DBF file in Excel.
(For other procedures, call the TrnExportCSV or TrnExportDBF function.)
Q: How do I get trend data into MS Access?
A: You can get data into Access in three ways:
-
Display the trend on the screen, select the Clipboard tool to copy the data, and use the Access Paste command to paste the data into Access.
-
Display the trend on the screen and select the File Save/As tool. Save the data in CSV format, and open the CSV file in Access.
-
Display the trend on the screen and select the File Save/As tool. Save the data in DBF format and open the DBF file in Access.
(For other procedures, call the TrnExportCSV or TrnExportDBF function.)
Q: How do I update trend data?
A: Use the TrnSetTable function to write data back to the trend system.
Q: How do I get trend data into a report?
A: Use the TrnGetTable function.