Villeroy wrote:Connect 2 Base documents to your databases and drag tables from into the other. Should work flawlessly between databases of equal types.
If you want to see SQL JOINs between 2 databases, there is another trick:
Create a form in a stand alone document. Conncect the form to a row set in DB1. Add a subform and connect that one to a row set in DB2 linked to the main form through some common field.
The subform shows records related to the selected main form record.
Villeroy wrote:Spreadsheets are no databases.
Villeroy wrote:Pseudo-databases based on spreadsheets are read-only.
Spreadsheets have sheets with atomic cells. There are no tables, rows nor fields in a spreadsheet. A database driver for spreadsheets interpretes the used cell ranges of a sheet as if they were a database table. It does not convert nor import anything into a database.
What you tried to do is just the same as opening the documents copy sheets from one document to the other one. A database program will not do that. This is what you have to do in a spreadsheet program.
Villeroy wrote:The other solution with input forms might be rather insufficient since there are no indices in spreadsheets.
Villeroy wrote:You may keep the sheets and find a solution with VLOOKUP or something like that.
You may import spreadsheet ranges into a true relational database which can present data from many interrelated tables as one.
Editor_HU wrote:No, my problem is not a spreadsheet issue. I have a real database and in addition important but irregular data are stored in spreadsheets.
Villeroy wrote:It takes a spreadsheet program to modify either the structure (move sheets) or the data (sheet contents).
Villeroy wrote:The same Base connection can not bundle links to one or more databases with data from sheets and other sources.
Villeroy wrote:MS Access can do that but it won't let you edit the sheets neither.
Villeroy wrote:The form/subform solution requires that you are familiar with manual creation of forms (we have something in the tutorial section).
Villeroy wrote:For similar tasks I use to dump everything into one spreadsheet, rearrange things to properly formed tables and use that scratch pad as a merged data source.
When I connect to an Oracle database, I do it using ODBC. When I read a table defined in Excel, I do it using ODBC. ODBC should hide the nature of the orogonal data, from Base point of view I want to work with two ODBC sources and am keen on combining fields from them.
Villeroy wrote:This is not normal. [Tutorial] The User Profile
Users browsing this forum: No registered users and 7 guests