Downloading large data into excel + connection ti

[santhonyd]

Hi Everyone i am encountering the following problem:<BR><BR> My asp file trasfer large chunk of data from database into excel sheet, but it gives the following error error 'ASP 0113'<BR>Connection timed out.If the response type is html i can use the page property of record set i can distribute it many pages.How do i handle this error in excel, i want the entire data in the single excel sheet<BR><BR>mabey you can enlarge the server timeout for ms sql server<BR>or you try to insert the data not at once. try to insert row after row<BR>alex