Access OLE link to ExcelLocked
I have a user that wants an Access (2K) table to be updated any time a row is added to an Excel spreadsheet. Add a row to Excel, have a row added to an Access table with some of the data from Excel. Cascading changes on update to Excel would be nice, but is not required. Has anyone done such a thing?