插入数据从形式到表形式、数据

2023-09-08 11:04:51 作者:高冷病友

它已经可能3年,因为我不得不使用VB或VBA code。我正在工作,我需要把列出的表格上的信息,并将其插入到表中的项目。我是停留在为c的值部分$ C $的最后一部分。这是我到目前为止所。

it's been probably 3 years since I have had to use VB or VBA code. I am working on a project for work where I need to take the information that is listed on the form and insert it into a table. What I am stuck on is the last part of the code the values part. This is what I have so far.

INSERT志愿者(姓名,邮箱,号码,紧急联络,紧急号码)VALUES(这是我卡住)

INSERT Volunteers (Name, Email, Number, Emergency Contact, Emergency Number) VALUES (and this is where I get stuck)

感谢大家提前!

推荐答案

INSERT志愿者(姓名,邮箱,号码,紧急联络,紧急号码)VALUES('NAME_VALUE','Email_Value,数值要打','Emergency_Value, 数值要打) 是语法这里更多的信息更详细信息链接到SQL插入

INSERT Volunteers (Name, Email, Number, Emergency Contact, Emergency Number) VALUES ('Name_Value','Email_Value','Number_Value','Emergency_Value','Number_Value') is the syntax for more info here is more details Link to SQL Insert