把excel带表头导入到listview,该如何解决

把excel带表头导入到listview
如题,不知道怎么弄,请大家帮忙,最好同时也放到SQL SERVER里。万分感谢。

------解决方案--------------------
VB code

        Set Conn_qc = Server.CreateObject("ADODB.Connection")
    Driver = "Provider=Microsoft.Jet.OLEDB.4.0;"
    DBParm = "Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";"
    DBPath = "Data Source=" & tmpfilename & ";" 
    Conn_qc.Open Driver & DBPath & DBParm
    
    Set rst=Conn_qc.OpenSchema(20)
    TableName = rst("Table_name")
    rst.Close
    
    Sql="Select * From [" & TableName & "]"
    
    
    rst.open sql, Conn_qc, 1, 1 
    if rst.recordcount<>0 then
    
        for j=0 to rst.recordcount-1

                            
                sql="insert into tbltest(Code,Name) values('"& rst(1) &"','"& rst(5) &"') "
                conn.execute(sql)


                end if    
            end if
            rst.movenext
        next
    end if
    rst.close
    set rst=nothing
    Conn_qc.close