Click here to Skip to main content
15,918,303 members
Home / Discussions / Database
   

Database

 
QuestionSQL Server security Pin
Fad B29-Dec-05 6:50
Fad B29-Dec-05 6:50 
AnswerRe: SQL Server security Pin
Colin Angus Mackay29-Dec-05 15:38
Colin Angus Mackay29-Dec-05 15:38 
GeneralRe: SQL Server security Pin
Paul Conrad29-Dec-05 18:25
professionalPaul Conrad29-Dec-05 18:25 
GeneralRe: SQL Server security Pin
Fad B29-Dec-05 21:14
Fad B29-Dec-05 21:14 
GeneralRe: SQL Server security Pin
Fad B29-Dec-05 21:15
Fad B29-Dec-05 21:15 
QuestionParsing Text file w/ multple datasets and schema.ini? Pin
Joshua Lunsford29-Dec-05 6:33
Joshua Lunsford29-Dec-05 6:33 
QuestionExport xls from sql Pin
GoodQuestion28-Dec-05 6:52
GoodQuestion28-Dec-05 6:52 
AnswerRe: Export xls from sql Pin
S Douglas5-Jan-06 0:31
professionalS Douglas5-Jan-06 0:31 
GoodQuestion wrote:
Export xls from sql


The easiest way to export data from a database to an excel file is through an Select into querry. I know this works on an Access db, never thought of trying it on an SQL server but it should still work (using ADO).

CString str;
str.Format("SELECT * INTO [Excel 8.0;DATABASE=%s].[%s] FROM [%s]", ExcelFile, Worksheet, table);

//pConn is a ADODB Connection
pConn->Execute(str.AllocSysString(), NULL, adExecuteNoRecords);



ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

thedailywtf.com[^]

-- modified at 6:31 Thursday 5th January, 2006
GeneralRe: Export xls from sql Pin
GoodQuestion11-Jan-06 12:02
GoodQuestion11-Jan-06 12:02 
QuestionSQL table organization for authentication Pin
shapper28-Dec-05 3:48
shapper28-Dec-05 3:48 
AnswerRe: SQL table organization for authentication Pin
Paul Conrad28-Dec-05 6:38
professionalPaul Conrad28-Dec-05 6:38 
GeneralRe: SQL table organization for authentication Pin
Paul Conrad28-Dec-05 6:51
professionalPaul Conrad28-Dec-05 6:51 
Questionhow to declare the procedures Pin
sasire1828-Dec-05 0:53
sasire1828-Dec-05 0:53 
AnswerRe: how to declare the procedures Pin
S. Akif Kamal28-Dec-05 1:24
S. Akif Kamal28-Dec-05 1:24 
Questionstoring xml doc in asp page uisng sqlserver Pin
suneelbabu_net27-Dec-05 19:02
suneelbabu_net27-Dec-05 19:02 
Questionstoring xml file in sqlserver Pin
suneelbabu_net27-Dec-05 15:59
suneelbabu_net27-Dec-05 15:59 
AnswerRe: storing xml file in sqlserver Pin
rihdus27-Dec-05 18:19
rihdus27-Dec-05 18:19 
GeneralRe: storing xml file in sqlserver Pin
suneelbabu_net27-Dec-05 18:42
suneelbabu_net27-Dec-05 18:42 
QuestionMS-SQL server Self join Pin
Amit Malik25-Dec-05 19:11
Amit Malik25-Dec-05 19:11 
AnswerRe: MS-SQL server Self join Pin
Michael Potter27-Dec-05 3:22
Michael Potter27-Dec-05 3:22 
Questiondelete trigger Pin
Vipin.d25-Dec-05 17:16
Vipin.d25-Dec-05 17:16 
AnswerRe: delete trigger Pin
Colin Angus Mackay26-Dec-05 2:40
Colin Angus Mackay26-Dec-05 2:40 
Questionneed help about database Pin
ngAnhTuan24-Dec-05 20:54
ngAnhTuan24-Dec-05 20:54 
AnswerRe: need help about database Pin
Colin Angus Mackay26-Dec-05 2:37
Colin Angus Mackay26-Dec-05 2:37 
GeneralRe: need help about database Pin
Paul Conrad28-Dec-05 5:34
professionalPaul Conrad28-Dec-05 5:34 

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.