Page 1 of 1
Link a spreadsheet to a database file
Posted: Wed Nov 28, 2007 12:42 pm
by 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?
Re: Link a spreadsheet to a database file
Posted: Wed Nov 28, 2007 4:43 pm
by 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?