I am trying to figure out how to open/save an Excel file to a field in a SQL Server table from within an Access database. My first choice it to open/save from and to the file system and track file meta data in the SQL Server table, however, the decision is out of my hands. Can anyone suggest any resources or perhaps point me to some sample code on how to accomplish this?
The user experience is to be the following. User is using an Access database to view information stored in a record. For each record a list of Excel files should be present that the user can select from and view. Then the user can save any changes to the Excel file as a new revision, which is stored in the database.