You can do it but it requres a reasonably good understanding of VBA macros
and ADO Recordsets.

Reading the data into a spreadsheet is relatively easy. You can use Data -
Import External Data - New Database Query... It is writing back that is
the tricky part.
--
HTH...

Jim Thomlinson


"Chase" wrote:

Can you set up an Excel spreadsheet which can act as a view of a Access table
and allow direct update of that table?

If possible how do I set it up?

Regards

Charles Moore