Edit Linked Excel files in Access

Linked Excel files have been read only in Access since 2002 when Microsoft removed the ability to edit them directly. Normally developers either use automation or import the file, edit then export back to Excel.
However, there is a much better method which is not widely known about. This video shows how linked Excel files can be directly edited in Access. New records can also be added.
This approach relies on setting the IMEX value = 0

For further information, see my article: https://www.isladogs.co.uk/edit-data-...

TIMES:
0:40 Properties of linked CSV/TXT files
0:48 Properties of linked Excel files
1:20 A better solution for Excel files
1:45 Example database with linked files
3:50 Method 1: create query to external Excel file
4:40 Query SQL - set IMEX = 0 to make query editable ; query read only if IMEX = 1 or 2 (default value)
6:10 Editable form with 'external' query as record source
6:22 Linked Excel table is editable whilst form is open
6:55 Methods 2: In recent versions of Access (2021/365), can edit connection strings in linked table manager. Change IMEX value to 0 (from default 2). Linked table is now directly editable
8:25 Neither method works for CSV / TXT files
9:33 Summary of both methods