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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel Conditional Statements 11 39
Excel Formula 5 45
Excel Spacing Anomaly 4 23
How to copy formulas in 1 column through manual page breaks in Excel 1 27
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

777 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