OpenOffice.org's database component, building on the HSQLDB database engine.

learn more… | top users | synonyms

3
votes
1answer
71 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
0
votes
1answer
22 views

OpenOffice showing syntax eror

Here's what I have so far: SELECT DISTINCT Min("gpa"."current_gpa"), "students"."lastname", "students"."firstname" FROM "students", "gpa" WHERE ...
0
votes
1answer
394 views

Can LibreOffice Base directly use MySQL syntax?

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
1
vote
1answer
131 views

Database workflow advice? [closed]

I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I ...
3
votes
1answer
633 views

How can I open a .mdb with a password in OpenOffice?

I'm trying to open a .mdb with a password in OpenOffice Base. I can connect to the .mdb, but I cannot specify a password (forums say this method doesn't support passwords). Is there a way I can open ...
0
votes
1answer
189 views

Split sheet by rule (filter) in Open Office

I want to split a large sheet. I have different products and for each of them I would like a new file. Is it possible to split the sheet by some rule? P.S. I am new in here, so if my question is ...
2
votes
1answer
913 views

OpenOffice Base locked

I ran into an issue with my open office base file. It appears to be locked (I have file.odb and file.odb.lck). Now I can open the base file, but as soon as I select Tables it crashes on me and when ...
0
votes
1answer
899 views

Access MS SQL server from CentOS (OpenOffice calc)

I installed FreeTDS in CentOS 6 and I can connect from php to remote MS SQL server. However I cannot set up odbc connection so that it shows in list of ODBC connections in OpenOffice apps. If my ...
0
votes
1answer
390 views

Displaying OpenOffice Base data in Excel

Is this possible? I assume I need an ODBC driver or other recognised from Excel/Query to access Base.
1
vote
1answer
434 views

Forms are Read-Only in Open Office Base

I'm in Open Office Base and I want to add records to an existing table/form, but it says read-only. I've already checked the Properties How can I add new records?
2
votes
2answers
2k views

Database access through odbc driver and excel

Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file? The program I am accessing data only allows an ODBC connection ...
2
votes
2answers
1k views

How do I use address data in Calc to populate labels in Writer in the OpenOffice.org suite?

I have a list of mailing addresses in a calc spreadsheet - one column per line in the address. I want to print them out on a sheet of labels. When I open a new labels document, there doesn't appear ...