excel spreadsheet embedded on an access form

[nedder]

I have an excel spreadsheet embedded on an access form that I would like to have tied to a record in the db. Currently, it stays static from one record to the next. Is this at all possible? And if so, could someone point me in the right direction on how to do this?


Thank you in advance for any assistance on this matter!!!!!

[llkhoutx]

Link the xls spreadsheet to your mdb as a table and use that linked table as the record source for a related subform. A simple test in A2007 worked and tumbled subform records, but the linked table was not updateable. I didn't fiddle with the properties.

Another approach would be to import the spreasheet into a table and then exporting it back when you finished with it (both using "docmd.TransferSpreadsheet").

I didn't investigate ODBC or OLE connections. They may solve or obviate the linked xls sheet updateablility issue directly from the link in Access.

If you have SharePoint, their may be another solution.

Please post what you learn.

[llkhoutx]

Look here for other ideas.