ho provato anche cosi'

Insert INTO act (data_dal, data_al, act, note, anno) VALUES ('prova1', 'prova2', 'prova3', 'prova4','prova5' )
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/admin/ACT_add_proc.asp, line 26

data_dal = Request.Form("data_dal")
data_al = Request.Form("data_al")
act = Request.Form("act")
note = Request.Form("note")
anno = Request.Form("anno")

SQL = " Insert INTO act (data_dal, data_al, act, note, anno) VALUES ('"& data_dal &"', '"& data_al &"', '"& act &"', '"& note &"','"& anno &"' )"
'SQL = " Insert INTO act (data_dal, data_al, act, note, anno) VALUES ('"& quote(data_dal) &"', '"& quote(data_al) &"', '"& quote(act) &"', '"& quote(note) &"', '"& quote(anno) &"' )"
Response.Write SQL
Set RSact = Conn.Execute(SQL)