Calc can be used as a Simple Database [OpenOffice Calc]

On June 18, 2010, in Database, OpenOffice.org Calc, by stephanie
0

For those interested in using Calc as a simple database, there is a simple step-by-step tutorial available to show you how.

From the tutorial:

A Calc document is a very capable database, providing sufficient functionality to satisfy the needs of many users. This chapter presents the capabilities of a Calc document that make it suitable as a database tool. Where applicable, the functionality is explained using both the GUI (Graphical User Interface) and macros.

Go to Calc as a Simple Database now

Tagged with: • • • • •
 

Databases for Other Operating Systems

On August 3, 2007, in Base, Database, by stephanie
0

Yesterday I wrote a brief post on links to visit for converting your Microsoft Access Database to an OpenOffice Base database. This only works for Windows-based installations.

For those using database formats such as mySQL, Oracle, etc, you should visit MDB Tools.

For some, the best solution might be to open the database on a Windows machine using OpenOffice Base and then convert first prior to moving to a non-Windows machine.

Tagged with: • • •
 

OpenOffice Database Conversion – MDB

On August 2, 2007, in Base, Database, by stephanie
1

For those that have Microsoft Access databases which they wish to use in OpenOffice, this is now supported. There is a wiki page that will give you more information here, however the most often asked question is answered as per the following:

Can I use Microsoft Access databases (.mdb) in Base?

On Windows: yes. You cannot open them directly via File|Open, but you can access the data therein. For this, you need the Microsoft Data Access Components, which are available from Microsoft for free. (In Windows XP, they”re already included, so you need them for older Windows versions only.)

For more information on OpenOffice Base, visit the Base FAQs and the main page on OpenOffice Base

Tagged with: • • • •