Click here to Skip to main content
16,018,419 members
Home / Discussions / Database
   

Database

 
GeneralAccessing fixed length data field Pin
Andrew Hoole6-Jan-04 1:35
Andrew Hoole6-Jan-04 1:35 
GeneralMillions of records per day Pin
coge5-Jan-04 21:11
coge5-Jan-04 21:11 
GeneralRe: Millions of records per day Pin
DiWa5-Jan-04 21:49
DiWa5-Jan-04 21:49 
GeneralRe: Millions of records per day Pin
Mike Dimmick6-Jan-04 2:49
Mike Dimmick6-Jan-04 2:49 
GeneralRe: Millions of records per day Pin
coge6-Jan-04 9:53
coge6-Jan-04 9:53 
GeneralRe: Millions of records per day [modified] Pin
Marek Grzenkowicz8-Jan-04 6:06
Marek Grzenkowicz8-Jan-04 6:06 
GeneralExport to XLS Pin
mosquitooth4-Jan-04 21:49
mosquitooth4-Jan-04 21:49 
GeneralRe: Export to XLS Pin
chinni16-Jan-09 23:24
chinni16-Jan-09 23:24 
See if the following works for you:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\Orders.xls;Extended Properties=""Excel 8.0;HDR=NO"""

Dim ExcelConnection As New System.Data.OleDb.OleDbConnection(ConnectionString )
ExcelConnection.Open()

Dim ExcelCommand As System.Data.OleDb.OleDbCommand = ExcelConnection.CreateCommand()

ExcelCommand.CommandText = "SELECT * INTO [Orders] FROM [Orders] IN '' [ODBC;Driver={SQL
Server};Server=(local);Database=Northwind;Trusted_ Connection=yes];"
ExcelCommand.CommandType = CommandType.Text
ExcelCommand.ExecuteNonQuery()

ExcelConnection.Close()

Smile | :)
Generalplease help me,my project......... Pin
Ahmed Gaser3-Jan-04 23:15
Ahmed Gaser3-Jan-04 23:15 
GeneralRe: please help me,my project......... Pin
preinsko6-Jan-04 18:55
preinsko6-Jan-04 18:55 
GeneralDELETE [table] gives syntax error Pin
Vaclav3-Jan-04 12:35
Vaclav3-Jan-04 12:35 
GeneralRe: DELETE [table] gives syntax error Pin
Guillermo Rivero3-Jan-04 17:45
Guillermo Rivero3-Jan-04 17:45 
GeneralRe: DELETE [table] gives syntax error Pin
winay7-Jan-04 2:08
winay7-Jan-04 2:08 
GeneralSql server stored procedure timing out problem Pin
pankajdaga1-Jan-04 10:51
pankajdaga1-Jan-04 10:51 
GeneralRe: Sql server stored procedure timing out problem [modified] Pin
Marek Grzenkowicz2-Jan-04 5:19
Marek 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
pankajdaga15-Jan-04 2:05 
GeneralRe: Sql server stored procedure timing out problem Pin
Mike Dimmick8-Jan-04 5:59
Mike Dimmick8-Jan-04 5:59 
GeneralRe: Sql server stored procedure timing out problem Pin
pankajdaga15-Jan-04 1:40
pankajdaga15-Jan-04 1:40 
GeneralSQL to FOX Pin
Majid Shahabfar31-Dec-03 6:09
Majid Shahabfar31-Dec-03 6:09 
GeneralRe: SQL to FOX Pin
Mazdak31-Dec-03 19:06
Mazdak31-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
Itanium30-Dec-03 1:59 
GeneralRe: open UDL Dialog at runtime Pin
Mazdak31-Dec-03 19:26
Mazdak31-Dec-03 19:26 
GeneralRe: open UDL Dialog at runtime Pin
Itanium31-Dec-03 21:45
Itanium31-Dec-03 21:45 

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.