How can I connect to MS Access Database

rahuld3

Hi !

I am new to PHP.I read that DSN is needed to connect to the MS Access database.But I did not find any clu as to what code has to be written in the PHP file to display the data from a table in MS Access.Please do help me in that.

I am really a beginner.Can anybody help me in this regard

thanks

Anon

// connect to a DSN with a user and password "marin"
$connect = odbc_connect("DSN", "UID", "PWD");
// query the users table for name and surname
$query = "SELECT First as First_Name, Last as Last_Name, Address, Position FROM employees WHERE Last='$name'";

// perform the query
$result = odbc_exec($connect, $query);