【VB开源代码栏目提醒】：以下是网学会员为您推荐的VB开源代码-grade_insert.frm，希望本篇文章对您学习有所帮助。

    VERSION 5.00
    Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
    Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
    Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "COMDLG32.OCX"
    Begin VB.Form grade_insert 
       Caption         =   "成绩导入"
       ClientHeight    =   5655
       ClientLeft      =   60
       ClientTop       =   345
       ClientWidth     =   7800
       LinkTopic       =   "Form1"
       ScaleHeight     =   5655
       ScaleWidth      =   7800
       StartUpPosition =   2  '屏幕中心
       Begin MSAdodcLib.Adodc Adodc1 
          Height          =   375
          Left            =   5280
          Top             =   480
          Visible         =   0   'False
          Width           =   1200
          _ExtentX        =   2117
          _ExtentY        =   661
          ConnectMode     =   0
          CursorLocation  =   3
          IsolationLevel  =   -1
          ConnectionTimeout=   15
          CommandTimeout  =   30
          CursorType      =   3
          LockType        =   3
          CommandType     =   8
          CursorOptions   =   0
          CacheSize       =   50
          MaxRecords      =   0
          BOFAction       =   0
          EOFAction       =   0
          ConnectStringType=   1
          Appearance      =   1
          BackColor       =   -2147483643
          ForeColor       =   -2147483640
          Orientation     =   0
          Enabled         =   -1
          Connect         =   ""
          OLEDBString     =   ""
          OLEDBFile       =   ""
          DataSourceName  =   ""
          OtherAttributes =   ""
          UserName        =   ""
          Password        =   ""
          RecordSource    =   "select zkzh as 准考证号,name as ,tname as 考试种类,fs as 分数 from info_grade"
          Caption         =   "Adodc1"
          BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "宋体"
             Size            =   9
             Charset         =   134
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          _Version        =   393216
       End
       Begin MSDataGridLib.DataGrid DataGrid1 
          Bindings        =   "grade_insert.frx":0000
          Height          =   4575
          Left            =   120
          TabIndex        =   1
          Top             =   840
          Width           =   7575
          _ExtentX        =   13361
          _ExtentY        =   8070
          _Version        =   393216
          HeadLines       =   1
          RowHeight       =   15
          BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "宋体"
             Size            =   9
             Charset         =   134
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "宋体"
             Size            =   9
             Charset         =   134
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          ColumnCount     =   2
          BeginProperty Column00 
             DataField       =   ""
             Caption         =   ""
             BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
                Type            =   0
                Format          =   ""
                HaveTrueFalseNull=   0
                FirstDayOfWeek  =   0
                FirstWeekOfYear =   0
                LCID            =   2052
                SubFormatType   =   0
             EndProperty
          EndProperty
          BeginProperty Column01 
             DataField       =   ""
             Caption         =   ""
             BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
                Type            =   0
                Format          =   ""
                HaveTrueFalseNull=   0
                FirstDayOfWeek  =   0
                FirstWeekOfYear =   0
                LCID            =   2052
                SubFormatType   =   0
             EndProperty
          EndProperty
          SplitCount      =   1
          BeginProperty Split0 
             BeginProperty Column00 
             EndProperty
             BeginProperty Column01 
             EndProperty
          EndProperty
       End
       Begin MSComDlg.CommonDialog CommonDialog1 
          Left            =   4200
          Top             =   120
          _ExtentX        =   847
          _ExtentY        =   847
          _Version        =   393216
       End
       Begin VB.CommandButton Command1 
          Caption         =   "导入"
          Height          =   495
          Left            =   2520
          TabIndex        =   0
          Top             =   120
          Width           =   1335
       End
    End
    Attribute VB_Name = "grade_insert"
    Attribute VB_GlobalNameSpace = False
    Attribute VB_Creatable = False
    Attribute VB_PredeclaredId = True
    Attribute VB_Exposed = False
    Private Sub Command1_Click()
    Dim str As String
    Set cn = New ADODB.Connection
    Set rs = New ADODB.Recordset
    Me.CommonDialog1.ShowOpen
    str = Me.CommonDialog1.FileName
    right1 = Right(str, 3)
     If right1 <> "dbf" Then
      MsgBox "请选择正确的表进行导入"
     Else
        cn.ConnectionString = "provider=msdasql;DRIVER=Microsoft Visual FoxPro Driver;UID=;Deleted=yes;Null=no;Collate=Machine;BackgroundFetch=no;Exclusive=No;SourceType=DBF;SourceDB=" & str & ""
        sql = "select * from '" & str & "'"
       Set rs = cn.Execute(sql)
       cn1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\file.mdb;Persist Security Info=False"
       sql1 = "select * from info_grade"
       rs1.Open sql1, cn1, 3, 2
       Do While rs.EOF <> True
         rs1.AddNew
         rs1!zkzh = rs!zkzh
         rs1!Name = rs!Name
         rs1!tname = rs!tname
         rs1!fs = rs!fs
         rs1.Update
        rs.MoveNext
        Loop
        MsgBox "导入成功"
       ' Me.Adodc1.Refresh
       'Me.DataGrid1.Refresh
      End If
    End Sub
    
    Private Sub Form_Load()
    Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & App.Path & "\file.mdb;Persist Security Info=False"
    End Sub