Ask Your Question

Unable to set up database

asked 2019-04-10 18:00:36 +0200

Yama gravatar image

updated 2019-04-10 19:53:42 +0200

Ratslinger gravatar image

The documentation for this program is so poor it's unbelievable. Setting up a basic database shouldn't be so difficult.

My issue stems from not being able to copy and paste from another program. Apparently copy and paste from Excel doesn't work so I have first imported it to Calc and then used the select cells, edit function, then gone to Base and done the paste function to open up the paste criteria window.

My database is eg. ID [INTEGER (AUTO)], COL1, COL2, COL3.

I go to the Base paste window and select the APPEND DATA button and in the next screen it shows my 3 cols from Calc in the left panel and ID, COL1, COL2, COL3 in the right panel. It won't paste in because of some stupid mismatch with the ID INTEGER. There is no way to set the program to ignore this column. There is no way to move it in the right column, only be moving the others above it, but then it comes up with some other message. My INTEGER is my primary key.

What am I doing wrong and why is there not a simple copy and paste function straight into the table? If you try to paste it in manually, the contents of every cell you've copied and paste into a single cell in Base.

edit retag flag offensive close merge delete


Figured it out! Have to add an empty ID column in the spreadsheet then deselect the column from the left panel in the import screen and it works OK then. Nothing about this in the documentation.. Found out from a random video on youtube !

Yama gravatar imageYama ( 2019-04-10 19:04:25 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-04-10 19:45:32 +0200

Ratslinger gravatar image


Adding the extra column is not necessary. Here are steps:

Table used:

image description

Existing data in table (can also be empty):

image description

Calc data:

image description

Copy Calc data & paste in table - First dialog (append data & use first line for Col names):

image description

After Next, get this screen:

image description

Must match fields (move auto incr field to bottom - use arrows on right):

image description

Then Create and resulting data is:

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2019-04-10 18:00:36 +0200

Seen: 42 times

Last updated: Apr 10 '19