ASP Application - Excel Export

Posted on 2009-05-19
Last Modified: 2012-05-07
We have an ASP 3.0 application that uses SQL 2005 for the database.  One feature we have is that ability to export database records to an excel spreadsheet.  For example a user will be on a page and click export records.  A window will pop up and prompt them to save or open the file.  If they click save, it saves to the desktop (or any location they save it to) very fast.  The file itself is only 2.5MB.  It has about 4,000 records and about 50 columns of data.  We think there is no problem exporting the data to excel as the file saves very fast.  However, when you try to open the file, it can take up to 5 minutes to open.  Excel just hangs as it is trying to open the file.  The file itself is not very big, but we think this may be because when the file is exporting to excel, it may be exporting all HTML in the background (not sure if that is correct though).  We are just using standard ASP 3.0 code to export that data.  Can someone please suggest the best method for exporting this file to excel without the issue we are having.  It still must be done in ASP as the applicaiton is an ASP app.  

Thank You --
Question by:sam1492
  • 2
  • 2

Expert Comment

ID: 24427744
Check out  Although I'm not sure it works with classic ASP.  You are referring to ASP and not ASP.Net right?

Author Comment

ID: 24427765
Thanks for the site.  It seems like it is for ASP.Net while our app is classic ASP.  
LVL 30

Accepted Solution

Wayne Barron earned 125 total points
ID: 24427778
Link is no good.

Try out the following (I have used these in the past)
Export Data to Excel using ASP

Good Luck
LVL 30

Expert Comment

by:Wayne Barron
ID: 24427788
Sam did you see Tim's link? Were you able to view the page?
As I got a [Sorry, '' does not exist or is not available.]

Anyway, hope that my information helps you.
Good Luck

Assisted Solution

TimSledge earned 125 total points
ID: 24427966
Sorry, I did not spell it correctly.  Try this:

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

828 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