Applies To:
  • CitectSCADA 1.xx, 2.xx, 3.xx, 4.xx, 5.xx

I am losing data that I enter into Citect DBASE files using Excel 95/97. 

In Excel 4, there was a "Set Database" menu item which let you set the highlighted area as a database to save in DBASE format for use in Citect. It was removed in Excel 95 and 97. Instead, when you click on the drop down box next to the entry field under the icon bar (which usually displays the cell number), a name called "Database" appears which, if selected, will highlight the current database settings. If you try to add records outside of this selection (such as to the end of the list), they are not saved, and there appears to be no way to resize the selection !

The trick here is that the "Database" selection is actually a set of "named" cells. If, when saving as DBASE format, Excel sees a name "Database", it will only save those cells. Therefore, to resize it, either click "Insert|Name|Define" and redefine the range for the name "Database", or delete it. If deleted, Excel will automatically set a new database name containing the consecutively filled rows/columns (ie, your data) when you save it as a DBASE file. Then it should work in the Project Editor. But don't forget to pack your database !!! :-)