| 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 !!! :-)
|
