Cannot add new records

[FTB2]

First, i am very new to databases. I created a database from an excel spreadsheet and created a report to meet our needs. I cannot add new records.

I did a search of this topic in this forum and tried some of the suggestions to no avail. I did see something about a "primary key" in my searches, but have no clue on how to reset, etc. What am I doing wrong?

[MrProgrammer]

Hi, and welcome to the forum.

I created a database from an excel spreadsheet and created a report to meet our needs. I cannot add new records.

If you used File → New → Database → Connect to an existing database → Spreadsheet, the data in Base is read-only. You add new records to the "database" by modifying the spreadsheet.
[Tutorial] Read-Only in Base

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[FTB2]

Ok, I understand. How can I create a database from a spreadsheet with it not being read-only?

[UnklDonald418]

The reason the database table is read only is that it has no Primary Key.
One solution is to copy the database table into one with a Primary Key.
Select the table name and press <Ctrl>C to copy it into the Windows clipboard
Press <Ctrl>V to paste the clipboard contents
That should open a Copy Table dialog.
Duplicate table names are not allowed so you will need to change the Table name
Select the Definition and data option
Select Create primary key, the default Name is fine.
Select the Create button.
Right click on the new table and select Edit.
In the table design GUI select the ID field
In the lower pane of the GUI window change Auto Value to Yes.
Save and close the table.
You should now be able to edit the new table in Base.
Editing table data directly offers very few formatting options.
To have more formatting control you need a Base Form.
You could use the Wizard to Create Form to generate a basic data form for data entry/edit.