sql server – Connecting OpenOffice Calc/Spreadsheet files

sql server – Connecting OpenOffice Calc/Spreadsheet files

While this is more of a comment than an answer, Im putting it here due to length.

OpenOffice Base is a front-end program that stores queries, forms, reports, and a connection to a back-end program. 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.

A limitation in your situation is that one Base file can use as a back-end only one Calc file. 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.

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. There is more information at [Tutorial] Using registered datasources in Calc and [Tutorial] Standalone Forms / Switchboard. Once the standalone form is set up a macro can be written to automatically copy data between databases.

Id second Lyri here: you cant use Calc as backend for SQL server (at least Id be very surprised if you could, esp. reliably).

If you want to stick w/ the Calc files, one idea could be: create a 2nd sheet and store a checksum for each row in that sheet. only update those rows that dont match the checksum any more into SQL server…

sql server – Connecting OpenOffice Calc/Spreadsheet files

Leave a Reply

Your email address will not be published. Required fields are marked *