This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / SQL Server->ASP->Excel problemSQL Server->ASP->Excel problem
I have a 28 columns table in SQL Server, and the table contains 14000 rows data.
It need to export data to Excel via ASP. I can select top 9000 rows or last 9000 rows with all columns, or select first 20 columns or last 20 clumns with entire rows. but it cannot use "SELECT * FROM TableName" to get all columns with entire rows data.
Does anyone know why and how to sovle the problem? Thanks.
-xxu999(杰姆);
2005-9-22
{434}
(#2514999@0)
-
probably it's because the data is too big so http server time out. check your web server setting and modify the time out value.
-holdon(again);
2005-9-22
(#2515233@0)
-
How to do it? Thanks.
-xxu999(杰姆);
2005-9-23
(#2516716@0)
-
as a result, it appears "HTTP 500" error messages. How to solve set /modify HTTP server timeout
-xxu999(杰姆);
2005-9-23
(#2516852@0)
-
http://www.netline.ch/support/info/aspcomp/safileup/install_tailor_scripttimeout.htm
http://www.intermedia.net/support/kb/default.asp?id=666
-holdon(again);
2005-9-23
(#2517469@0)
-
you problem should be in the display side, you can get all the return, but can not display all of them. try to put them in a file first
-boer_ioi(Job Searching);
2005-9-22
(#2515352@0)
-
put reponse.flush behind the line where you write out the row, if it's too slow, flush one each 300 or 500 rows, hope this will help you
-nickxiaow(均可);
2005-10-1
(#2532415@0)