• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

ASP Application - Excel Export

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 --
0
sam1492
Asked:
sam1492
  • 2
  • 2
2 Solutions
 
TimSledgeCommented:
Check out www.speadsheetgear.com.  Although I'm not sure it works with classic ASP.  You are referring to ASP and not ASP.Net right?
0
 
sam1492Author Commented:
Thanks for the site.  It seems like it is for ASP.Net while our app is classic ASP.  
0
 
Wayne BarronCommented:
Tim
Link is no good.

Try out the following (I have used these in the past)
Export Data to Excel using ASP
http://www.theukwebdesigncompany.com/articles/article.php?article=730

Good Luck
Carrzkiss
0
 
Wayne BarronCommented:
Sam did you see Tim's link? Were you able to view the page?
As I got a [Sorry, 'www.speadsheetgear.com' does not exist or is not available.]

Anyway, hope that my information helps you.
Good Luck
Carrzkiss
0
 
TimSledgeCommented:
Sorry, I did not spell it correctly.  Try this:  http://www.spreadsheetgear.com
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now