Wrox Programmer Forums
|
ASP Pro Code Clinic As of Oct 5, 2005, this forum is now locked. No posts have been deleted. Please use "Classic ASP Professional" at: http://p2p.wrox.com/forum.asp?FORUM_ID=56 for discussions similar to the old ASP Pro Code Clinic or one of the other many remaining ASP and ASP.NET forums here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP Pro Code Clinic section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 24th, 2005, 02:45 PM
Registered User
 
Join Date: May 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Exporting to Excel

Hi guys,

I am stuck with a problem while exporting to Excel from asp.
I have to export abt 25K records to excel.I can successfully export 10k but the site where this application is hosted has server trasfer limit I am not able to export 25k+.
I tried writing to the xl file on the server and linking to the file on the browser.but I could write the records to the file but not able to display the link as page errors out.

I am thinking of dividing the files into parts so that all the files r written.but I am not sure how can I go abt this?

if any one of you have taken this approach can you pls guide me?
or if any of u guys out there has any other suggestions/ideas let me know.:(

Thanks
 
Old May 24th, 2005, 06:01 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

When you cross post you run the risk of taking up twice as many peoples times as you need:

http://p2p.wrox.com/topic.asp?TOPIC_ID=30920

Wind is your friend
Matt
 
Old June 9th, 2005, 11:56 PM
Friend of Wrox
 
Join Date: Apr 2005
Posts: 128
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can use 2 DSNs or connection strings one for the database you are using for ASP and one for Excel. Fetch the ASP data first and then use an insert sql atatement for the Excel data sheet.I think this might work as it does not depend upon the server transfer limit.
 
Old June 15th, 2005, 04:11 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Best is to collect data from in chunks that would fit well within 10k from the db and write those in comma separated format and name the file with extension as ".csv"

Hope that helps.

_________________________
- Vijay G
Strive for Perfection





Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting to excel michaeltanfeliz Beginning VB 6 2 May 3rd, 2008 05:26 AM
Exporting From Access To Excel jimnich Access VBA 17 February 8th, 2008 07:23 AM
exporting to excel caveatashish Classic ASP Basics 0 November 3rd, 2006 05:08 AM
Exporting to Excel swhite Access VBA 2 September 18th, 2003 09:42 AM
Exporting to Excel JJ Access 1 June 9th, 2003 11:30 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.