Merging two Tables together

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Merging two Tables together

Postby michaelmorgan9 » Wed Mar 11, 2015 2:41 am

Hello,
I have two different databases on excel, i would like to merge both of them using three different "cells" from each table. For example, both databases have the addresses however the address are separated in three different cells, Which is the number of the house, whether is a street, drive or boulevard, and the name of the street. Is there a way i could combine both tables together ? I am new to this forum, if i am not clear please let me know
openoffice 4.1.1 on mac
michaelmorgan9
 
Posts: 1
Joined: Wed Mar 11, 2015 2:35 am

Re: Merging two Tables together

Postby calc-learner » Fri Apr 10, 2015 8:48 am

Seems you would like to combine data from two tables into one.

The easiest way I can think of to do this would be to:
1. Create 2 pivot tables in excel showing the three columns you want, one for each database.
2. Highlight the first table in your excel file and copy.
3. Paste this data into the calc file.
4. Highlight the second table in your excel file(but do not highlight the column names this time).
5. Paste the second table below the first table.
6. Press F4 and open the (+ sign) database you want the data to go to. Highlight the data and drag it onto "Table". Follow the wizard from there.

Cheers!
Apache OpenOffice 4.1.2 Windows 10 Enterprise
calc-learner
 
Posts: 34
Joined: Fri Oct 10, 2014 10:14 am

Re: Merging two Tables together

Postby MTP » Fri Apr 10, 2015 7:35 pm

These forums are for OpenOffice and LibreOffice, which make a word processor called Writer, a spreadsheet named Calc, a database manager called Base, and other components of office software. You posted specifically in the forum for Base. Are you actually looking to use the software Base?

I ask because your post references only Excel, which is a competing spreadsheet made by Microsoft. Are you just in the wrong forum? You may have better luck posting in a different site that supports Microsoft products.
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests