Super User
Super User

Questions tagged [openoffice-base]

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

OpenOffice.org's database component, building on the HSQLDB database engine. Allows accessing other database servers (e.g. postgreSQL) using ODBC/JDBC, making SQL database engines available for OpenOffice.org users.

Useful external links:

16 questions
5
votes
1 answer

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 this file using Base?
rtf
  • 12,826
4
votes
1 answer

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 would be out of the question. (or OOBase/MySQL…
user332893
4
votes
1 answer

Populate foreign key using combo/dropdown on form

I'd like to populate a foreign key field in one table using a combobox/dropdown where the values the user sees are not the IDs but a description field from the foreign table. Consider the following setup: create table people ( id int identity…
LondonRob
  • 455
2
votes
0 answers

How do I combine data in two tables in LibreOffice?

I have a spreadsheet with two sheets. SheetA has Customer number and location, and SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and location? Every column of SheetA is unique, but SheetB may…
user2430974
  • 21
2
votes
1 answer

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 I open any of the Reports, it crashes on me. How…
George
  • 354
  • 1
  • 3
  • 19
2
votes
2 answers

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 in. Not sure what database it is.
Daniel
  • 1,445
2
votes
2 answers

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 to be an option to set the source of the label…
Erick Robertson
  • 778
1
vote
2 answers

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 flavors of SQL. What I'm significantly hazier on…
HamComa
  • 155
  • 1
  • 4
1
vote
1 answer

Database workflow advice?

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 then need to modify a couple of columns and then…
Pete Q
  • 145
1
vote
1 answer

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?
Robyn
  • 11
  • 2
0
votes
1 answer

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 "students"."id" = "gpa"."id" HAVING ((…
user60839
0
votes
1 answer

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 somehow not appropriate, just tell me.
Oriesok Vlassky
  • 101
0
votes
1 answer

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 server is called [10.0.0.11\myinstance] in…
Milan
  • 195
0
votes
1 answer

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.
Jeff
  • 1
0
votes
1 answer

Can Open Office (or any open source database program) convert .ACCDT files to .MDB?

Can Open Office (or any open source database program) convert .ACCDT files to .MDB? This is specifically about the template, hence .ACCDT and not the database file .ACCDB. Tools I have available is "MS Access 2003". Researching this for a charity…
GngrWtch
  • 111
1
2