Update/Append Linked Excel with new Data added into Access

[WhatscookinDoc]

NEWB here
I have a Excel 365 spreadsheet data source that is LINKED to Access 365 db and I would like to enter data into an access form and then have the new RECORD update/APPEND the excel spreadsheet with a button click?


Any help with this would be greatly appreciated.

Thanks
WhatscookinDoc

[isladogs]

Linked Excel spreadsheets are read only in Access.
However, there are various ways of doing what you want including automation (which will require code) or creating a query to the external Excel workbook (which can be editable).

However, neither of these are beginner level solutions

[Micron]

for automation, check out http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm

Then there is TransferSpreadsheet method?

[WhatscookinDoc]

Thanks Isladogs. Looks like I've got some learning to do.

[WhatscookinDoc]

Thanks Micron.
I had a quick look at your links. Thank you. The info is very indepth.
This may be a project thats a little over my head at this point. I will play with your info an see if I can make some sense out of it.

[Micron]

Thanks Micron.
I had a quick look at your links. Thank you. The info is very indepth.
This may be a project thats a little over my head at this point. I will play with your info an see if I can make some sense out of it.

Much of the code that is available can be copied and modified to suit but it certainly is easier if you can make sense of what is going on when you try to adapt it to your situation. We're here for when you get stuck with that.