Solved

ASP, Excel and MsAccess

Posted on 1998-09-07
10
261 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

0
Comment
Question by:Patricia080698
  • 3
  • 3
  • 3
  • +1
10 Comments
 
LVL 28

Expert Comment

by:sybe
ID: 1828554
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

0
 
LVL 1

Author Comment

by:Patricia080698
ID: 1828555
How can I display my Excel datasheet directly through asp? Is there a place where I can get some info about this?
0
 
LVL 10

Expert Comment

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

0
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
LVL 28

Expert Comment

by:sybe
ID: 1828557
I have seen it once in a magazine. Anyway, there is a ODBC-driver for Excel.
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1828558
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.
0
 
LVL 1

Author Comment

by:Patricia080698
ID: 1828559
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.
0
 
LVL 28

Expert Comment

by:sybe
ID: 1828560
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.
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1828561
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.  
0
 
LVL 1

Author Comment

by:Patricia080698
ID: 1828562
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.
0
 
LVL 11

Accepted Solution

by:
mouatts earned 50 total points
ID: 1828563
As has already been stated you can access the spreadsheet via ODBC. Within the ASP page you open a connection to your spreadsheet. EG
<%Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "DBQ=" & LocalPath & "Database\prices.xls;Driver={Microsoft Excel Driver (*.xls)};" %>

You then issue the SQL command which will be along the lines of
SELECT price FROM PRICE_LIST
using the execute method
This returns a record set which you can cycle through to read each item using the Move method.
Finaly you close the connection.

Steve
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you get a (Blue Screen of Death), your system writes a small file called a minidump. Your first step is to make certain your computer is setup to record memory dumps. Right click My Computer, choose properties. Click on the advanced tab, an…
This article will show, step by step, how to integrate R code into a R Sweave document
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question