![]() ![]() ![]() Once the standalone form is set up a macro can be written to automatically copy data between databases. There is more information at Using registered datasources in Calc and Standalone Forms / Switchboard. 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. Method 5 can not work because Excel does not know registered databases. Base is a fully featured desktop database management system, designed to meet the needs of a broad array of users, from tracking a personal CD collections. Method 4 can not work because there is no DDE function in Excel. Method 3 may work (range imported by range name). Method 2 may work (linked visible sheet). ![]() 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. Tutorial External Links In Calc Method 1 fails with exported xls. 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. While this is more of a comment than an answer, I'm putting it here due to length. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |