Can you update a linked table from an excel document in Access?

[Ganymede]

My access database has a linked table from an excel document. I would like to be able to run an append query from my database to add records to the excel document. Is this possible? I have researched this a bit and what I'm reading (from posts 5+ years ago) that a linked table from excel will always be read only.

[June7]

Can make a link to Excel sheet editable, except for row delete. Requires changing connection string IMEX parameter to 0.

There's a couple of ways to link to Excel table.
Can use External Data wizard to create link then use Linked Table Manager to edit the link string.
Other way is to build a query object that has connection string. Example:

SELECT * FROM [Units$] IN 'C:\Users\June\Condos.xlsx'[Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes];

[Ganymede]

Can make a link to Excel sheet editable, except for row delete. Requires changing connection string IMEX parameter to 0.

There's a couple of ways to link to Excel table.
Can use External Data wizard to create link then use Linked Table Manager to edit the link string.
Other way is to build a query object that has connection string. Example:

SELECT * FROM [Units$] IN 'C:\Users\June\Condos.xlsx'[Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes];

Thank you! Changing the IMEX parameter to 0 in the linked table manager worked for me! Marking as resolved.

[CJ_London]

Just be aware that unlike databases, excel does not have any datatyping so there is nothing to stop a user entering text in a date or numeric field - unless you put in the relevant control to prevent that happening.

[June7]

As far as I can tell, link does enforce data types. Cannot enter text into a column assigned as number or date type.

True, if wrong data entered directly in Excel, will cause an error in the linked table.