Tom Pajak wrote:
I have an existing database, for which I would like to delete all of the existing records and reload a fresh set of data. I will need to do this repetitively. After searching in some of the forums and support documentation, I have not been able to find anything that guides me in how to do that. I must be looking for the wrong keywords, being new to using Openoffice to set up a database. The source of the new set of data, by the way, will always be a spreadsheet, with the same column headings. In fact there ares several data bases sourced from cooresponding spreadsheets for which I would like to build relationships. Any guidance would be appreciated.
Sorry if I misunderstand your intent...Actually it is the damned way Base was constructed that helps feed such ambiguity I suppose.
Do you mean to say that you have a Base file that connects to a spreadsheet as its source of data?
If so then this is a read only file from Bases perspective. You can not delete the data in your spreadsheet from the Base side therefore.
A spreadsheet feeding data to a Base file is not a relational database so there is no such thing as a relation. A spreadsheet is by definition a flat file. ( well a collection of flat files might be a better definition, looking at each sheet as a separate file )
Now if you are using Base as a way of using your spreadsheet data for a mail merge function or in a set of reports - AND - periodically you receive new spreadsheet files, each with the same structure as the previous. Then this processing of new files is very simple.
The Base holds a configuration setting which is the full file name for the spreadsheet it is connected to. In the GUI you can find this at Edit>Database>Properties. The data may be read only but that property of the Base file is not - You can either change it to point to the new file, or of course you could just move the old spreadsheet ( rename it ) and move in the new. Either way yields the same results.
I hope that helps, some. Drew --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
