Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello @moonscape,

What you are attempting is to have Base, which has a data source connection already, connect to another data source in order to pass data from one source to another. You stated:

I used to to this exact same thing in Access and it was very easy using "linked" tables which were directly linked to an xls file.

Base does not contain this function. It can be done through Macros (have done as a test but it is complex) within Base itself. In your case it may be better to write a macro in Calc, select information and have a macro there access and update the appropriate DB.

Macros, especially of this type, are not easily created and are specific to your needs.

One similar request, tdf#56234, has been on the books for some time. There may be other requests.