We help IT Professionals succeed at work.

ASP, Excel and MsAccess

Patricia080698
on
Medium Priority
292 Views
Last Modified: 2013-12-25
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

Comment
Watch Question

Commented:
With ASP it is possible to retrieve data directly from Excel and display it browsers, so you don't need the way through Access.

By the way, did you solve to "Order" problem (Q.10077588), there are some suggestions waiting for you

Author

Commented:
How can I display my Excel datasheet directly through asp? Is there a place where I can get some info about this?

Commented:
you will need to first set up a DSN in your ODBC with a type of Excel rather than Access..

Commented:
I have seen it once in a magazine. Anyway, there is a ODBC-driver for Excel.

Commented:
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.

Author

Commented:
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.

Commented:
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.

Commented:
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.  

Author

Commented:
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.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.