Re: spreadsheets as database
"Anthony E. Greene" <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Franco Fornari wrote: > Hello, > > I'm trying to use a Calc spreadsheet as database. In Base I can see all > its sheets as tables, but it's not allowed to build queries based on > more than one table/sheet. There is any way/workaround to do this? If you're working in an environment where you can write scripts, and the downloaded data is in a format that can be handled by your scripting language, then you can write a script that connects to (or opens) the database, deletes the old records, then imports the new records from the downloaded file(s). -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Anthony E. Greene <mailto:[email protected]> 0x6C94239D iD8DBQFE2/sppCpg3WyUI50RAhr8AJ4upjUEk83ru9bTeRawc+aQXD3fkACgjkby 7kceejqMq+NNHDQMlK6vWFA= =+uSF -----END PGP SIGNATURE-----