Import data

Discuss the database features

Import data

Postby 01Pad » Wed May 29, 2019 5:01 pm

Hi
I am familiar with documents and spreadsheets, but a complete newbie when it comes to databases.
In Word, I had a mailmerge system set up which took data out of a table in one word document and merged it into a report. simple.
I have learned that this is not possible in OOO. I have to make a database and do a report from that.
I have been running a fix which also had a large document with a table in it, and I cut and pasted the line I wanted into a report. This has been fairly successful, if laborious, and the source document, which is added to every week, is becoming very slow to load.
I need to have some random access database on the HDD which can grow without clogging up RAM too much.
I could do this on the ZX Spectrum many years ago (My first computer back in the 80s) but am struggling now.
So I have spent a frustrating and interesting couple of hours trying again to make it work with a database.
I have exported the data from my old table into a csv file.
I have created a database (and registered it - whatever that means), and have set out a table that specifies the data I need, using the titles in the csv file.
But I can't find a way of linking the two documents. It seems to want always to impose my data onto an address book with its own titles.
I have looked through the beginner guides, but can find nothing that helps me with this task.
If there is someone out there who can advise, I'd be very grateful.
Many thanks
Paddy
OpenOffice 3.1 on Win 10
01Pad
 
Posts: 1
Joined: Wed May 29, 2019 4:48 pm

Re: Import data

Postby Villeroy » Wed May 29, 2019 7:42 pm

It is possible with https://libreoffice.org/ which is the successor of OpenOffice. It can connect a database to a text document with text tables.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28551
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Import data

Postby robleyd » Fri May 31, 2019 9:43 am

Same question posted at AskLibreOffice

Have you looked at the Mail Merge feature described in chapter 11 of the Writer Guide?
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3463
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Base

Who is online

Users browsing this forum: Google [Bot] and 4 guests