在access中建立一数据库student,其中有ID 文本型 name 文本型 age 长整型
如果
dim age as long
dim id as string
dim name as string
在insert into 语句如何使用上面三个变量
如果
dim age as long
dim id as string
dim name as string
在insert into 语句如何使用上面三个变量
sql="insert into tableName (id,name,age) values('"+id+"','"+name+"',"+age)
Dim sSql As String
Dim conn As New ADODB.Connection
Dim age as long
Dim id as string
Dim name as string
Dim x As Integer--> 给age,id,name赋值.conn.Open ("provider=Microsoft.Jet.OLEDB.4.0;Data source =[mdb文件];Persist Security Info=True;Jet OLEDB:Database Password=[密码]")
sSql = "insert into [表名] values('" & Trim(id) & "','" & Trim(name) & "','" & CStr(age) & "' "conn.Execute sSql, x
conn.CloseSet conn = Nothing