PHP and Access with INSERT

[Anon]

How can I insert records into an Access database with PHP? Many thanks.

[garyr]

Add your Access database on the System DSN
(Windows Control Panel/ODBC Data Sources)

Then try testing this code snippet:

<?
$dsn = 'your_dsn';
$dbuser = '';
$dbpasswd = '';

$dbconn_id = odbc_connect($dsn, $dbuser, $dbpasswd);

$sql_cmd = "INSERT INTO table_name VALUES ('value1', 'value2', 'etc..')" ;
odbc_exec($dbconn_id, $sql_cmd);

echo "1 record inserted!<p>";

odbc_close($dbconn_id);

?>

Hope this helps!