insert data from excel to mysql

  • Hi,
    i have a problem when inserting more than two data from excel.


    above only can insert one data.


    if i try

    Code
    1. sq = "Insert into user (usr_name, usr_pwd) values ('" & a & "' & ',' & '" & b & "')"


    error "column count doesn't match value count at row 1".


    Please help.