Linking Excel to Access

  • Thread starter Thread starter Court Smith via AccessMonster.com
  • Start date Start date
C

Court Smith via AccessMonster.com

I have a spreadsheet that contains a high proportion of calculated cells.
I would like to link an Access database to it, and then use the database as
the conduit to my dynamic webpages. I am using Macromedia Ultradev 4 to
dynamically link my Access databases to my webpages. A link between my
Excel sheets and my Access tables would be helpful. I intend to use the
Access tables to recieve input data from the webpages, link it to Excel,
Excel performs the calculations, then Access sends it back to the webpages
as output. All of this without human interaction.

Is there an easy way to do this? Or is there an easy way to directly
connect the spreadsheets to the webpages with Ultradev?
 
I suggest do the calculation in the webpage instead of doing it in excel.
Too complex and you have to do many checking.
 
The calculations are very extensive. It would take a very long time to
write the calcs in either the webpages or in Access VBA.
 
Back
Top