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.