How Add the additional row to existing table

Question

I have a excel file having table in it with data, which I linked some jobs in access, where I added some row via Access Append Query. it was successful, it got added.

when I open the excel file, I can see that it got added but it does not get added in the table. Below is the image of the screen

Is it possible, to manually added the below rows into the table data group.

pls. guide

Answer 1

To add the existing rows:

• Click anywhere in the table.
• Activate the Table Design tab of the ribbon.
• Click Resize Table in the Properties group.
• Select the entire range.

In the future, to add a new row, click in the cell in the lower right corner of the table, then press Tab

Answer 2

Thank you,

I was able to include in the range, but when trying to publish it is showing the below error "Read only"

Note : the table is connected to MS Teams Table (which I created via PowerApp screen and then selected the option to edit in excel so that easily I can add the data of append from access ),

Till here I am going ok, but the another stuck me again,

pls. guide

please guide

Answer 3

something similar situation discussion I found in the below link but could not understand the solution

https://community.dynamics.com/forums/thread/details/?threadid=2b547a78-21b1-4fe8-9cad-e7d2b3f0eb9c#:~:text=Hi%2C-,%22Changes%20made%20to%20read%2Donly%20fields%20will%20be%20reverted%2C,That's%20why%20the%20warning%20appears.

if possible pls review and guide

Answer 4

I'm afraid I don't know anything about that, sorry.

Answer 5

Thank you Mr. HansV,

I have learnt a lot from your advise in MS Access programming, you have helped so many times in the Access community.

Further to my below query, I was able to solve, Posting it here if any user can get to this situation:

While testing and experimenting found that If you keep the workbook open, run the Ms Access append command for the table (which is linked to this work book)

Then appended data get inserted into the table of sheet instead of lying outside the table , and After running publish it accepts and update the the Dataverse Teams Table.

Regards