sqlstr="insert into ad(num,thesis name, writer, publication name,ingestiontype,impact factor,amount) values("&num&",'"&thesis name&"','"&writer&"','"&publication name&"','"&ingestiontype&"','"&impact factor&"','"&amount&"')"
语句以分号结尾，你加分号了没