Link a spreadsheet to a database file

[rayswchiu]

i used to link different spreadsheets template to an Access database file, using to external data source feature in Excel. Can i perform the same in OpenOffice? How?

[DrewJensen]

You can do it - but you go about it in the reverse order so to speak.

You can create a linked named range in a Calc sheet that gets its data from a Base table, this can be setup as a nearly live link - meaning you have to refresh it to get the new data, but that can also be setup with a macro to happen every time the sheet is opened - it can also then be setup as an action on a Base form.

So - you could build a form in Base for data entry and then use a simple macro to update the changed data into the Calc file.

Would that be along the lines of what you are looking for?