下面代码运行时出现错误‘找不到可安装的ISAM’Private Sub Command2_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cn1 As New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=" & App.Path & "\Test.xls;ExtendedProperties='Excel8.0;HDR=Yes;IMEX=1'"
Setrs = cn.Execute("Select StageNo,RhythmNo,NoteNo,DelayTM,NoteTM,NoteNM From[Sheet1$]")
cn1.Open "Provider=SQLOLEDB.1;Password=123;PersistSecurityInfo=True;UserID=sa;InitialCatalog=Mgame;DataSource=(local)"
Do While Not rs.EOF
cn1.Execute ("Insert Into GameData(StageNo,RhythmNo,NoteNo,DelayTM,NoteTM,NoteNM) VALUES('" & Format(rs(0)) & "','" & Format(rs(0)) & "','" & Format(rs(1)) & "','" & Format(rs(2)) & "','" & Format(rs(3)) & "','" & Format(rs(4)) & "','" & Format(rs(5)) & "')")
rs.MoveNext
Loop
rs.Close
cn.Close
cn1.Close
Set rs = Nothing
Set cn = Nothing
Set cn1 = Nothing
End Sub
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cn1 As New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=" & App.Path & "\Test.xls;ExtendedProperties='Excel8.0;HDR=Yes;IMEX=1'"
Setrs = cn.Execute("Select StageNo,RhythmNo,NoteNo,DelayTM,NoteTM,NoteNM From[Sheet1$]")
cn1.Open "Provider=SQLOLEDB.1;Password=123;PersistSecurityInfo=True;UserID=sa;InitialCatalog=Mgame;DataSource=(local)"
Do While Not rs.EOF
cn1.Execute ("Insert Into GameData(StageNo,RhythmNo,NoteNo,DelayTM,NoteTM,NoteNM) VALUES('" & Format(rs(0)) & "','" & Format(rs(0)) & "','" & Format(rs(1)) & "','" & Format(rs(2)) & "','" & Format(rs(3)) & "','" & Format(rs(4)) & "','" & Format(rs(5)) & "')")
rs.MoveNext
Loop
rs.Close
cn.Close
cn1.Close
Set rs = Nothing
Set cn = Nothing
Set cn1 = Nothing
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货