Rockwell Automation 9301 Series RSView32 Users Guide - Manual (Page 581)

Sharing data with other Windows applications

16–19
Tag name
Creating a pivot table in Microsoft Excel
Use a pivot table to display and analyze data from any narrow–format
.dbf log file.
The basic steps for creating a pivot table are:
Open Microsoft Excel and start the PivotTable ® Wizard
Select the data source
Join tables and select data
Organize the pivot table
This column Contains SQL Data Type Length
TagName The tag name. SQL_VARCHAR or
SQL_CHAR 255
TagIndex The index number assigned to the tag
name. SQL_SMALLINT
or SQL_INTEGER 2
TagType The tag type:
2—analog tag
3—digital tag
4—string tag
SQL_SMALLINT 1
TagDataType The tag data type:
0—long
1—float
2—string
SQL_SMALLINT 2