Click here to Skip to main content
15,922,574 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Multiple Sapce problem Pin
Abhijit Jana3-Feb-08 22:30
professionalAbhijit Jana3-Feb-08 22:30 
GeneralRe: Multiple Sapce problem Pin
N a v a n e e t h3-Feb-08 22:33
N a v a n e e t h3-Feb-08 22:33 
GeneralRe: Multiple Sapce problem Pin
Abhijit Jana3-Feb-08 22:39
professionalAbhijit Jana3-Feb-08 22:39 
GeneralRe: Multiple Sapce problem Pin
N a v a n e e t h3-Feb-08 22:46
N a v a n e e t h3-Feb-08 22:46 
AnswerRe: Multiple Sapce problem Pin
Abhijit Jana4-Feb-08 0:33
professionalAbhijit Jana4-Feb-08 0:33 
Generalfiltering lookup in sharepoint Pin
ptvce3-Feb-08 20:46
ptvce3-Feb-08 20:46 
Generalasp.net + access 2003 Pin
ritu43213-Feb-08 20:12
ritu43213-Feb-08 20:12 
GeneralRe: asp.net + access 2003 Pin
dilipv8-Feb-08 0:26
dilipv8-Feb-08 0:26 
GeneralIIS 7 VISTA problam Pin
galigal153-Feb-08 19:46
galigal153-Feb-08 19:46 
GeneralMasterPage and Javascript Pin
trilokharry3-Feb-08 18:52
trilokharry3-Feb-08 18:52 
GeneralRe: MasterPage and Javascript Pin
N a v a n e e t h3-Feb-08 19:34
N a v a n e e t h3-Feb-08 19:34 
AnswerRe: MasterPage and Javascript Pin
Raam3-Feb-08 21:58
Raam3-Feb-08 21:58 
GeneralNamespace for xquery Pin
VanithaVasu3-Feb-08 18:35
VanithaVasu3-Feb-08 18:35 
QuestionHow to print ReportViewer1 Pin
faisallal3-Feb-08 17:50
faisallal3-Feb-08 17:50 
GeneralHelp in generate Excel Data Pin
HatakeKaKaShi3-Feb-08 16:39
HatakeKaKaShi3-Feb-08 16:39 
GeneralRe: Help in generate Excel Data Pin
Venkatesh Mookkan3-Feb-08 17:19
Venkatesh Mookkan3-Feb-08 17:19 
HatakeKaKaShi wrote:
I need to generate a large number of records from SQL server 2000 to and excel spreadsheet.


Are you using the Excel COM object (will be slower) or HTML to Excel method to generate the Excel file?

HatakeKaKaShi wrote:
However the durations of time id too long. For about 900 records there's about 50 min.


It depends on the business logic used to generate the excel.

SQL Server 2005 has the ability to export to excel directly using OPENROWSET (INSERT INTO OPENROWSET) methodology. Check whether SQL Server 2000 also has that command.


[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

GeneralRe: Help in generate Excel Data Pin
HatakeKaKaShi3-Feb-08 20:32
HatakeKaKaShi3-Feb-08 20:32 
GeneralUn loading page Pin
Lijo Rajan3-Feb-08 16:36
Lijo Rajan3-Feb-08 16:36 
GeneralRe: Un loading page Pin
Guffa3-Feb-08 16:48
Guffa3-Feb-08 16:48 
GeneralRe: Un loading page Pin
John-ph3-Feb-08 21:12
John-ph3-Feb-08 21:12 
GeneralNEED HELP Pin
Mahendar3-Feb-08 6:09
Mahendar3-Feb-08 6:09 
GeneralRe: NEED HELP Pin
Paul Conrad3-Feb-08 7:00
professionalPaul Conrad3-Feb-08 7:00 
GeneralRe: NEED HELP Pin
Guffa3-Feb-08 16:15
Guffa3-Feb-08 16:15 
GeneralRe: NEED HELP Pin
dilipv3-Feb-08 19:47
dilipv3-Feb-08 19:47 
Questionshowing cathegorizied pictures..? Pin
Mir_As3-Feb-08 5:20
Mir_As3-Feb-08 5:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.