str="insert into classmate (student_ID,classmate_name,sex,chamber_number,chamber_phone,QQ,mobile_phone,number_intro)
values('"&id&"','"&name&"','"&sex&"','"&chamber&"',"&phone_number&",'"&qq&"','"&mobile_phone&"','"&intro&"')"
你这里有个换行,这句把所有换行都去掉.
str="insert into classmate (student_ID,classmate_name,sex,chamber_number,chamber_phone,QQ,mobile_phone,number_intro) values('"&id&"','"&name&"','"&sex&"','"&chamber&"',"&phone_number&",'"&qq&"','"&mobile_phone&"','"&intro&"')"