Use of Excel with ASP

G

geode

I have an application that uses an Access front-end to
pass numbers to Excel and then saves the results of the
Excel calculations back in Access.
I would like to know if I can keep the EXCEL workbook for
the calculations (they are too complicated to translate
easily) and create an ASP for the front end.
I intend to change Access to SQL tables.

I've never worked with Frontpage so an example or
reference would be appreciated.
 
J

Jon

Hi,
can you give us more details on what you're doing? In this newsgroup a
front-end would always be a web page - are you saying you're taking some
data from the user doing some funky calculations in Excel and storing the
result in Access? Depending on your server setup using Excel from a web page
would fall somewhere between not advisable and impossible.

Really excel is not a viable option - you would need to look at performing
your business logic in ASP and/or your db - they're well capable of doing
what you need but we would need more details to be able to help you atall

Jon
Microsoft MVP - FP
 
Top