inserting into access

[Anon]

hi,
I am trying to insert some info in the access db but I cant do it at all. I am getting a syntax error. Has anyone inserted anything into an acess db let me know.
Vishal

[nostradamus]

I have insertet data into a access DB and it worked fine.
I used the followin Syntax in php :

$db = odbc_connect ("Testdb","","");
$in = odbc_exec ($db,"INSERT INTO Formular (Kunde, Strasse, PLZ, Ort) VALUES ('".$Kunde."','".$Strasse."','".$PLZ."','".$Ort."');");
odbc_close_all();