How to add data to the access table in vb

zhouhui1123

I wrote a program recently, but I can't write it all the time. Ask a master. I want to insert the value in an array xm (1 to 9) into the field "project name" in the table dykz in dyin.mdb, as well as other fields. The code is as follows:
dim i as integer
   i=1
  for i = 1 to 9
     insert into dykz("Project name")　valuse (xm(i))
   next i
"Dykz has no end of sentence" error
Do you want to connect to the database? ? Please give me a more comprehensive and detailed code, preferably with comments, I am a novice, love to learn, please give me a little encouragement!

pronice

conn.execute("insert into dykz (project name)　valuse ('"&xm(i)&"')"

zhouhui1123

Do you want to add a little statement to connect to the database? Is this only enough?

pronice

Click the "Project" menu and select "Reference"
Select "Microsoft ActiveX Data Objects 2.0 Libray" or above in the list

establish connection
Dim conn As New ADODB.Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database path"

dim xm(1)
xm(0)="123"
xm(1)="321"
for i = 0 to ubound(xm)
  'Add to database
  conn.execute("insert into dykz (project name)　valuse ('"&xm(i)&"')"
next i

zhouhui1123

Thank youpronice, but
conn.execute("insert into dykz (project name)　valuse ('"&xm(i)&"')")
There is a grammatical error in this sentence, please help me see