Once the standalone form is set up a macro can be written to automatically copy data between databases. When working with databases, you will come to a point where the basic features are not sufficient. There is more information at Using registered datasources in Calc and Standalone Forms / Switchboard. Org Base and Basic - Roberto Benitez has been gaining popularity over the years, and with the introduction of the database module (Base) in release 2.0, there has been more to learn. OpenOffice for free - Download OpenOffice OpenOffice for free Take advantage of OpenOffice’s free Office. While each one Base file can connect to only one back-end, transfer between databases can be done by using another OpenOffice component (usually Writer or Calc) to connect to multiple Base files.

Could your data be exported to csv? In that case Base could be set up to read each (of the hundreds) csv file in the same folder as one table in a database. The back-end program manages the tables, and Base can connect to any number of back-ends, including MS SQL Server, MS Access, and OpenOffice Calc.Ī limitation in your situation is that one Base file can use as a back-end only one Calc file. OpenOffice Base is a front-end program that stores queries, forms, reports, and a connection to a back-end program. Database: This is an organised collection of information that can be easily accessed, managed and updated. In the File Type list of the Open window, select Text CSV (click in that list and type T four times). While this is more of a comment than an answer, I'm putting it here due to length.

Openoffice calc database