If your data is currently in a different RDMS, Whatever it is, it should have a tool to export the data to a CSV file. (Re-open it in OpenOffice's spreadsheet ("Calc"), tidy things as necessary, and proceed from the appropriate place below. If it is currently in a spreadsheet, your job is half done, almost certainly. If your data is currently in a text file, we are good to go. It is just a text file with a little structure. There's nothing particularly "magic" about a CSV file. If you wish, as I recommend to anyone who wants to really understand all of this, to "follow along", do what is described in this essay, copy/paste that text to a simple text editor, save as TmpBooksRead.txt. The tutorial had a major overhaul a while ago, under OpenOffice 3.1.0, and was tried again 9/19 under 4.1.6) The first datum in each record is a date. Converted to CSV form, that data looks like.ġ/15/19,"Angel Maker", "Pearson", 465, 1998ġ/27/19,"Lord of the Rings", "Tolkien", 1065, 1969Ģ/15/19,"Lion, Witch, Wardrobe", "Lewis", 256, 1970Īll those quote marks ("s) are pretty annoying, but the last record should show you why they are needed. It was in Borland's Paradox, and recorded the title, author, the number of pages, and the year I read each book. I've produced a separate page with a general discussion of CSV files.įrom long before ooBase came along, I have had a database with the names of books I've read. "CSV" stands for "Comma Separated Values". I have a page with my current forum recommendations for you.) (I find online forums are the most helpful source of help to me. Let's get started! But first I'd like to say "thanks" to JohnV at the now deceased Open Office Foru for the seed which grew into this tutorial. Copy the contents of the spreadsheet onto the clipboard.Fill an Open Office Calc spreadsheet with that data.Convert the old data to a "lingua Franca" called CSV.The plan for moving data to Base is simple. If I needed to append data from outside ooBase to an existing ooBase table, I would first import that data into a temporary ooBase table, and then append the contents of the temporary table to the existing table. I prefer to do things one step at a time. Let me mention one thing this tutorial will not show you: It will not show you how to append data from an outside source to an existing ooBase table. you don't need to give me your email address there's a simple little form for your convenience. Does the page already answer the questions you had? Etc? A quick note from you would be very welcome. If you will tell me what you came here for, I can concentrate editorial efforts on the parts of the page the most readers want expanded. The page you are reading seems to be popular, but I am not sure what it is that draws people to it, so I've started breaking it up into more focused pages. If your interest is in using ooBase to work with Microsoft Access databases in particular, the link just given has a few notes for you. but in the long run, you are going to encounter fewer hassles if you take the trouble to rebuild your database in ooBase. ooBase can, up to a point, work with data created by other >RDMSs. You may find that you don't need to do imports. Other tutorials explain how to move data between Open Office applications and how to export data from an Open Office application for use in an external application. In this tutorial tries to help you move data from other database managers into Open Office Base (aka ooBase) tables. Page contents © TK Boyd, Sheepdog Software ®, 2/06-9/19 (Enlarge, reduce, restore to default, respectively.) (This is more fully explained, and there's another tip, at my Power Browsing page.) With most browsers, pressing plus, minus or zero while the control key (ctrl) is held down will change the texts size. Make your browser window as wide as you want it. There's more about ooBase in the main index to this material. and saving million$, but still Getting The Job Done. Big organizations, government and civilian, are adopting it as their standard office suite. Remember that Open Office, including ooBase, is free! But don't let that fool you. You may find that the database which is part of Libre Office/ OpenOffice delights you as much as it has me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |