Using Excel as front end for Access Table

goggem

New Member
Joined
Apr 28, 2007
Messages
30
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!!
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,067
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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

New Member
Joined
Apr 28, 2007
Messages
30
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,057
Messages
5,599,545
Members
414,316
Latest member
ExcelLee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top