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 |
|
Babaksql
Starting Member
32 Posts |
 Posted - 2006-04-08 : 01:03:24
|
| Hi,I'd like to run a query in an asp.net page and then show the result in Excel for the user.My results are very large, almost 250,000 records.I'm thinking of using VBA. However I think it's not an efficent way.Anybody have a better idea. Thanks for your attention.Cheers |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-04-08 : 05:48:09
|
excel can hold max 64k nad change rowsand 256 columns max.so you wont be able to put that much data into excel.Go with the flow & have fun! Else fight the flow  Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"] |
 |
|
|
Babaksql
Starting Member
32 Posts |
Posted - 2006-04-08 : 09:29:31
|
| Thanks spirit1,I know that limitation.I want to check the number of inserted records and if it exceeds from 64K, I'll generaet a new sheet.I saw that some people suggested to use Response.Write method, but it's not clear for me. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-04-08 : 09:39:44
|
| http://www.codeproject.com/aspnet/owc11article.aspGo with the flow & have fun! Else fight the flow Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"] |
|
|
|
Babaksql
Starting Member
32 Posts |
Posted - 2006-04-09 : 02:23:16
|
| I tried to use Office Web Component. That's good until you want to add a new sheet.When you do that your previous sheet will be vanished. That's the problemI tried this link "http://www.eggheadcafe.com/articles/20021220.asp" |
|
|
|
|
|
|
Query results in Excel