Mamamia Syntax error in insert statement?

[yxz152830]

Scholars, why? Debug points to this... I'm lost. Thanks

sql = " insert into [sheet1$] (name， age， gender） values('shinjiang', 5, 'male')"
connection1.Execute sql

Sub adddata()
Dim connection1 As New ADODB.Connection
Dim data As New databaseclass
Dim sql As String
connection1.Open data.database12
sql = " insert into [sheet1$] (name， age， gender） values('shinjiang', 5, 'male')"

connection1.Execute sql
connection1.Close
Set connection1 = Nothing
End Sub

 

[Joe4]

Isn't this just the same question as this here?

Out of stack space

I'm trying to run a code and error gives me the topic message. how to solve it?

www.mrexcel.com

If so, you need to continue in the original thread, as per rule 12 here: Message Board Rules
Please do not start multiple threads on the same question.