Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ajay
Starting Member
34 Posts |
 Posted - 2002-08-28 : 03:52:58
|
| Hello,I need to export an big recordset (all records) from sql t an excel file.After settin the content type to msvnd-excel etc, the code works fine for nearly 2000 records, it shows them in excel file, but it does't work for 5000 records.Explorer always said cannot download etc etc.....Tried using rs.GetString, getRows etc but didn't work. I dont have file write permission on the server, so writing to text file and then exporting to excel is out of question.Now how do i show all these records in excel or for that matter on explorer.Increased the scripttimeout also but then it takes ages to download.We need to look at those records after every say 20 days.This kind of report format is needed.How can I implement this functionality in an ASP page.Any help is reallu appreciated.thanksajay |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-08-28 : 08:41:32
|
make sure you have output buffering turned ON. this will allow you to buffer the entire file and then send it to the browser all at once... I have done HTML excel reports before and have no trouble sending 15mb excel files to the browser (account data  )... |
 |
|
|
|
|
|
export to excel big recordset through asp