Ask Your Question

How to enter data into a Base table?

asked 2015-12-30 17:53:06 +0200

NS gravatar image

updated 2016-01-02 18:55:27 +0200

Alex Kemp gravatar image

I'm using 5.0. The language in my version is French but I'd prefer it to be English. I've created a table but not a formula. When I try to create a formula there's no wizard to help me. When I try to enter data directly into the table I'm told I can't. What can I do to rectify the situation?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-12-31 16:35:56 +0200

pierre-yves samyn gravatar image


May be you can not enter data because you have not define a primary key? If that is the case I suggest you to download here the Getting Started with Base guide that explains very well the concept.

Formulas are not created in the table. You need to create them in a query (see the guide).


edit flag offensive delete link more


Thanks very much for the reference. I'll now study the guide.

NS gravatar imageNS ( 2015-12-31 18:27:36 +0200 )edit

Hello again,

Having read part of the guide, I realize that I didn't construct my data base correctly. However, it does work to some extent and it has a lot of data in it. I don't want to have to enter all that piece by piece into a new data base which is properly constructed. Is there a way to avoid that?

Thanks in advance

NS gravatar imageNS ( 2016-01-01 14:52:10 +0200 )edit

Hi - There are several possibilities. Eg copy-paste a table triggers a wizard that allows you to create a new one by selecting fields and adding or not the data. It is also possible to use the menu ToolsSQL to run INSERT statements but you should give details to help you more precisely. Regards.

pierre-yves samyn gravatar imagepierre-yves samyn ( 2016-01-04 11:42:43 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-12-30 17:53:06 +0200

Seen: 1,034 times

Last updated: Dec 31 '15