Solved

ASP, Excel and MsAccess

Posted on 1998-09-07
10
271 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Stressed Out?

Watch some penguins on the livecam!

 
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

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

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

Making a simple AJAX shopping cart Couple years ago I made my first shopping cart, I used iframe and JavaScript, it was very good at that time, there were no sessions or AJAX, I used cookies on clients machine. Today we have more advanced techno…
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
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…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

688 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