Andis wrote:
Hello!
I have calc spreadsheet models for water management modelling with
rather complicated calculations and lot of data, so calc works with
them vary slowly. I want to separate data input from calculation part
and make database for input data and then use it as source for
calculation files.
My question - is it possible to assign database field to certain calc
cell like, for instance, in writer documents?
May be stupid question, but it would solve many problems for me.
Andis
Yes. What you are creating in Calc is a defined range, this range could
be as small as one cell or as large as a full sheet. But the key is that
it is linked to a rowset in a database. This can be either a table or query.
The easiest way to generate this is to simply drag and doip either a
table or query from a Base file to a Calc sheet. You will see all the
data, along with column names as headings move into the sheet.
Afterwords select 'Tools>Data' from the main menu. In this dialog box
you will now find an entry named "Import1". There are settings available
at the bottom of the dialog and good entries in the help system for what
they do.
For example, if you choose not to save the data in the sheet then the
transfer will automatically happen every time the Calc file is opened.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
