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

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

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.

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