Click here to Skip to main content
15,399,788 members
Home / Discussions / Database
   

Database

 
GeneralRe: Cross databases Pin
Ian Darling6-Jan-04 6:33
MemberIan Darling6-Jan-04 6:33 
GeneralAccessing fixed length data field Pin
Andrew Hoole6-Jan-04 1:35
MemberAndrew Hoole6-Jan-04 1:35 
GeneralMillions of records per day Pin
coge5-Jan-04 21:11
Membercoge5-Jan-04 21:11 
GeneralRe: Millions of records per day Pin
DiWa5-Jan-04 21:49
MemberDiWa5-Jan-04 21:49 
GeneralRe: Millions of records per day Pin
Mike Dimmick6-Jan-04 2:49
MemberMike Dimmick6-Jan-04 2:49 
GeneralRe: Millions of records per day Pin
coge6-Jan-04 9:53
Membercoge6-Jan-04 9:53 
GeneralRe: Millions of records per day [modified] Pin
Marek Grzenkowicz8-Jan-04 6:06
MemberMarek Grzenkowicz8-Jan-04 6:06 
GeneralExport to XLS Pin
mosquitooth4-Jan-04 21:49
Membermosquitooth4-Jan-04 21:49 
Hi
I run the following SQL- statement in my VB.NET
application to export the results of a query to Excel:
g.CommandText = "SELECT * INTO [Excel
8.0;DATABASE=C:\test.xls;HDR=NO;].Table1 FROM [MyTable]
WHERE... 'g is a valid OleDbCommand object

This statement fails, if the xls- file already exists.
I've heard that the INSERT INTO statement could deal with this - could anyone
provide me some SQL- string that does the trick??
Thanks a lot!

Can anyone help me?

Gordon
GeneralRe: Export to XLS Pin
chinni16-Jan-09 23:24
Memberchinni16-Jan-09 23:24 
Generalplease help me,my project......... Pin
Ahmed Gaser3-Jan-04 23:15
MemberAhmed Gaser3-Jan-04 23:15 
GeneralRe: please help me,my project......... Pin
preinsko6-Jan-04 18:55
Memberpreinsko6-Jan-04 18:55 
GeneralDELETE [table] gives syntax error Pin
Vaclav3-Jan-04 12:35
MemberVaclav3-Jan-04 12:35 
GeneralRe: DELETE [table] gives syntax error Pin
Guillermo Rivero3-Jan-04 17:45
MemberGuillermo Rivero3-Jan-04 17:45 
GeneralRe: DELETE [table] gives syntax error Pin
winay7-Jan-04 2:08
Memberwinay7-Jan-04 2:08 
GeneralSql server stored procedure timing out problem Pin
pankajdaga1-Jan-04 10:51
Memberpankajdaga1-Jan-04 10:51 
GeneralRe: Sql server stored procedure timing out problem [modified] Pin
Marek Grzenkowicz2-Jan-04 5:19
MemberMarek Grzenkowicz2-Jan-04 5:19 
GeneralRe: Sql server stored procedure timing out problem Pin
andyharman7-Jan-04 11:09
professionalandyharman7-Jan-04 11:09 
GeneralRe: Sql server stored procedure timing out problem Pin
pankajdaga15-Jan-04 2:05
Memberpankajdaga15-Jan-04 2:05 
GeneralRe: Sql server stored procedure timing out problem Pin
Mike Dimmick8-Jan-04 5:59
MemberMike Dimmick8-Jan-04 5:59 
GeneralRe: Sql server stored procedure timing out problem Pin
pankajdaga15-Jan-04 1:40
Memberpankajdaga15-Jan-04 1:40 
GeneralSQL to FOX Pin
Majid Shahabfar31-Dec-03 6:09
MemberMajid Shahabfar31-Dec-03 6:09 
GeneralRe: SQL to FOX Pin
Mazdak31-Dec-03 19:06
MemberMazdak31-Dec-03 19:06 
GeneralRunning SQL in Developer Studio Pin
Steve Schaneville31-Dec-03 4:23
professionalSteve Schaneville31-Dec-03 4:23 
Generalopen UDL Dialog at runtime Pin
Itanium30-Dec-03 1:59
MemberItanium30-Dec-03 1:59 
GeneralRe: open UDL Dialog at runtime Pin
Mazdak31-Dec-03 19:26
MemberMazdak31-Dec-03 19:26 

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.