Dim strnn As String
strnn = "" '联接字串。
cnn.Open strnn
End Sub
Sub write_data()
Dim i As Integer
Dim j As Integer
Dim str1 As String
i = 2
With Sheets("sis.xls")
Do While .Cells(i, 1) <> ""
'Debug.Print .Cells(i, 1)
str1 = "insert into t1(f1,f2,f3....) values('"
For j = 1 To 15
str1 = str1 & .Cells(i, j) & "','"
Next j
str1 = Left(str1, Len(str1) - 2) & ")"
cnn.Execute str1
i = i + 1
Loop
End With
End Sub
Dim strnn As String
strnn = "" '联接字串。
cnn.Open strnn
End Sub
Sub write_data()
Dim i As Integer
Dim j As Integer
Dim str1 As String
i = 2
With Sheets("sis.xls")
Do While .Cells(i, 1) <> ""
'Debug.Print .Cells(i, 1)
str1 = "insert into t1(f1,f2,f3....) values('"
For j = 1 To 15
str1 = str1 & .Cells(i, j) & "','"
Next j
str1 = Left(str1, Len(str1) - 2) & ")"
cnn.Execute str1
i = i + 1
Loop
End With
End Sub
试试!有问题可以再问我。
Dim cn As ADODB.Connection
Dim rsT As ADODB.Recordset
Set cn = Createobject("ADODB.Connection")
With cn
.Provider = "MSDASQL"
.ConnectionString = "Driver={Microsoft Excel Driver (*.xls)};" & _
"DBQ=xls文件物理路径"
.CursorLocation = adUseClient
.Open
End With
set rsT=createobject("adodb.recordset")
rsT.open "SELECT * FROM [Sheet1$]",cn,0,1
......