Integrate excel functionality into an access field? RRS feed

  • Question

  • I would like to develop an application (form) that can take data from an existing Oracle database and combine it with data from an "excel" field. My IT guys said they can link whatever I want out of the database.

    In other words I need a field on a form that is say 4 columns wide x 10 rows high with the bottom right cell being the cell that is used in other calculations on the form - I can invision an embedded excel sheet. The issue is that in the 4x10 area needs to function like excel so that users can fully customize how the bottom right value is calculated. In addition to this all the data in the sheet/field needs to stay and be saved with that particular record so that it can be reviewed and/or modified at a later date - I will have up to 300-400 records per data set or database. Any chance anyone out there has seen anything like this?

    Tuesday, October 12, 2010 5:14 PM