Base: Import Excel Data

Creating tables and queries

Base: Import Excel Data

Postby canoeheadca » Tue Feb 13, 2018 6:55 pm

Teaching myself Base

Trying to import some data from excel to Base. I have a table but when I try to paste copied data into the table from excel there is no paste option.

i did it yesterday...but today there does not seem to be a paste option no matter how i try.

can anyone help?

thanks
openOffice 4.1.5 on W10
canoeheadca
 
Posts: 2
Joined: Tue Feb 13, 2018 6:38 pm

Re: Base: Import Excel Data

Postby Villeroy » Tue Feb 13, 2018 7:15 pm

You can connect a database to an xls(x) document which gives a pseudo-databse for mail merger etc.
And you can simply open the file with OpenOffice, copy the data (with or without column labels), select a table icon in Base and paste. Follow the dialog which lets you choose several options and map incoming fields to the existing fields.
I do not recommend creating a new table from clipboard data. This leads to bad data types, import errors, consistency problems. Always import raw data into well prepared tables.
This forum has a section for Base tutorials and Base examples.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25381
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Base: Import Excel Data

Postby canoeheadca » Tue Feb 13, 2018 8:21 pm

Thanks, i think i am doing that...ive made a table with the proper fields and save the table, i then open excel and copy the data I want to move to Base. I right click on the Base table I created but no Paste option comes up.
openOffice 4.1.5 on W10
canoeheadca
 
Posts: 2
Joined: Tue Feb 13, 2018 6:38 pm

Re: Base: Import Excel Data

Postby Villeroy » Tue Feb 13, 2018 10:32 pm

The clipboard transfer works from Calc to Base, not from Excel to Base.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25381
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 2 guests