Patricia080698
asked on
ASP, Excel and MsAccess
I am trying to display an Excel worksheet onto my html page. I want to use MsAccess 95 to import the excel data, but before importing I also need to do some calculations in my excel colums(adding, substracting, etc.) I know that I can do this with macros (but should I do it in MsAccess or Excel?)
I am Using ASP, the list of items(what my excel datasheet contains) in excel is modified every month and sent to me as a .xls file. I need to know if there is an automatic way(maybe through ASP) to import this .xls file into my MSAccess, then do the calculations and afterwards display the hole table of items on my html page...Thanks
I am Using ASP, the list of items(what my excel datasheet contains) in excel is modified every month and sent to me as a .xls file. I need to know if there is an automatic way(maybe through ASP) to import this .xls file into my MSAccess, then do the calculations and afterwards display the hole table of items on my html page...Thanks
ASKER
How can I display my Excel datasheet directly through asp? Is there a place where I can get some info about this?
you will need to first set up a DSN in your ODBC with a type of Excel rather than Access..
I have seen it once in a magazine. Anyway, there is a ODBC-driver for Excel.
The driver is installed when you install Excel (97) on the computer.
There was an article in Avatar magazine once about creating a link to Excel, but It talked more along the lines of using the charting feature.
There was an article in Avatar magazine once about creating a link to Excel, but It talked more along the lines of using the charting feature.
ASKER
I know that I can export an excel datasheet to Access but I need to do some calculations to the price list before exporting it.
So do you need to change the spreadsheet before publishing it ?
Is it for an intranet ? and do you know what browsers the visitors will use.
You could also make a <a href=" "> to the spreadsheet. IE will open the spreadsheet and display it within the browser.
If you make the spreadsheet read-only, then no one will be able to change it.
I'll be chcking today how to make a ODBC connection to a spreadsheet.
Is it for an intranet ? and do you know what browsers the visitors will use.
You could also make a <a href=" "> to the spreadsheet. IE will open the spreadsheet and display it within the browser.
If you make the spreadsheet read-only, then no one will be able to change it.
I'll be chcking today how to make a ODBC connection to a spreadsheet.
You can make the calculation using ASP... Why do you need to do it in the spreadsheet? I would think you could get the data from Access and make the calculation then place them on the page.
ASKER
I was wondering if there was a way to directly print out my price list (which is in excel) on my html page. Through ASP.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
By the way, did you solve to "Order" problem (Q.10077588), there are some suggestions waiting for you