-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: sachingpatel
Message 3 in Discussion
New Message on BDOTNET
SQL SERVER OPENROWSET problem (insert bulk records from excel to sqlserver)
Reply
Reply to Sender
Recommend
Message 2 in Discussion
From:
sachingpatel
The following is the VB code, convert in
net language and you will get what you want.
Set oConnection = New ADODB.Connection
With
oConnection
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=" & "c:\test.xls" & ";Extended
Properties=""Excel 8.0;HDR=Yes;ReadOnly=False;IMEX=1;"""
.Open
End With
Set oWorksheetRS =
New ADODB.Recordset
With oWorksheetRS
.ActiveConnection =
oConnection
.CursorType = adOpenStatic
.LockType
= adLockBatchOptimistic
.CursorLocation = adUseClient
.Source = "SELECT * FROM [" & "datatab" & "$A:H]"
.Open
.Fields("LongString").Value = myWickedLongString ' STRING >
255
.Filter =
adFilterPendingRecords
.UpdateBatch adAffectGroup
.Close
End
With
oConnection.Close
Sachin Patel
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
