Andreas Saeger ha scritto:
Franco Fornari schrieb:
Hi Andreas,
yes, I certainly agree with all your suggestions, but the data I was
referring to come from the web in Excel format. Then, each time I'd
have to delete the old tables in my database and import the new ones
from the spreadsheet ,again. This is doable, sure, but I'd prefer,
each time, overwrite the spreadsheet, only. That's all. ;-)
Ciao,
Franco
I see. The sender is the problem.
Assuming you have got some document from the web, saved at URL
file://path/spreadsheet.ods, having a sheet named "Data" with some
list ("database-table") in range A1:Mxxxx
Open your working document.
Hit Ctrl+F3
Name: Import
Assigned to: 'file://path/spreadsheet.ods'#$Data.$A$1:$M65536
Now call Edit>Links ...
The dialog shows a spreadsheet-link and offers some commands:
- You can update the link (details below)
- You may change the source-file (which unfortunatly needs to have an
equally named sheet "Data"!)
- You may break the link, which won't be successfull as long as
anything references the external data.
Call Format>Sheet>Show...
You've got a data-copy (no formulas) of the "Data" sheet. The copied
sheet is named 'file://path/spreadsheet.ods'#$Data
When you refer to either one of 'file://path/spreadsheet.ods'#$Data or
named range "Import" in some formula, then you actually refer to this
sheet. You do not access the source file. It works even when the
source file has been moved.
When you get a new file://path/spreadsheet.ods, having a sheet named
"Data" with some list ("database-table") in range A1:Mxxxx, then you
just have to call Edit>Links>Update in order to replace the data on
hidden sheet 'file://path/spreadsheet.ods'#$Data.
There is another kind of links. See help on function DDE(). This wil
not create a hidden sheet. The file will be loaded invisible instead.
So it needs to be accessible. This kind of link can be set to
automatic update on recalculation.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi Andreas,
these are useful hints but, sorry, they seem to drive me far from my
needs to build queries with more than one table-sheet. As Ocke has
already confirmed, this is not possible, at present. :'(
I can see some different solutions, but each one needs more work and
doesn't seem very handy, unfortunately.
Ciao,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
