You can create the database based on comma-separated text files in OpenOffice.org by choosing File > New > Database, choosing to connect to an existing source, and choosing text files. Then, click "Next" and fill in the directory where the text files are. Each text file will become a table in the database. Be sure to fill in the other fields in the window as well, including the separators.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Updates to the text file will be reflected in the database in OpenOffice.org. You can update the text files in a text editor. Be sure the .odb database file is closed when you edit the text files.
You could also open the comma-separated text files in OpenOffice.org Calc. Make certain that you select the "Text CSV" file type option after you choose File > Open in the dropdown list. Creating a spreadsheet from the text files makes it easier to continue to enter and change the information, since a spreadsheet is generally easier to navigate around in than a text file.
To create a database based on spreadsheets, use the same approach: Choose File > New > Database,. Choose to connect to an existing source, but select Spreadsheet. Then click Next and select the spreadsheet. All sheets in the spreadsheet will become tables in the database.
Using a comma-separated text file output or spreadsheets based on those text files is definitely a quick way to convert to OpenOffice.org Base. Databases based on text, spreadsheets or address books are limited in some ways. You don't have all the features of OpenOffice.org's Base, such as the ability to write to the sources from data entry forms.
Dig Deeper on Open source databases
Related Q&A from Solveig Haugland
Our expert tells you how to use search to find strings in OpenOffice.org's Calc.continue reading
An office suite expert describes how to use ODBC with OpenOffice 2.0.continue reading
An office suite expert describes where to find information on OpenOffice 2.0's use in the enterprise worldwide.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.