Using Excel as front end for Access Table

[goggem]

I'm sure the code to do this is online somewhere, but I can't find it.

I want to make an Excel document which displays an Access table.

When a user changes a value in the Excel document, it writes the change to the Access table.

Additional features that would be great, but I will put these in myself if necessary:
- Keeping historical records of the changes made (so each record will have a record number and a date-last-modified)

Does anyone know where I can get the code to do this?

Thanks!!

 

[alansidman]

Open Access and instead of importing your Excel table, link it to Access. Follow the wizard to make this happen. Then any changes made to your Excel spreadsheet will be automatically reflected in your Access Table.

 

[goggem]

Open Access and instead of importing your Excel table, link it to Access. Follow the wizard to make this happen. Then any changes made to your Excel spreadsheet will be automatically reflected in your Access Table.

Thanks. I don't think this is what I want. I want to be able to record the changes that different people made.

Also, I only want a subset of the table displayed in Excel.