Page 1 of 1

Base: Import Excel Data

PostPosted: Tue Feb 13, 2018 6:55 pm
by canoeheadca
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

Re: Base: Import Excel Data

PostPosted: Tue Feb 13, 2018 7:15 pm
by Villeroy
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.

Re: Base: Import Excel Data

PostPosted: Tue Feb 13, 2018 8:21 pm
by canoeheadca
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.

Re: Base: Import Excel Data

PostPosted: Tue Feb 13, 2018 10:32 pm
by Villeroy
The clipboard transfer works from Calc to Base, not from Excel to Base.