//数据库连接字符串
OleDbConnection objConn = new OleDbConnection(Provider=Microsoft.Jet.OleDb.4.0;Data Source=D:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\Test\Test.mdb);
//打开数据连接
objConn.Open();
//申明SQL语句
string sql="";
//执行SQL语句
OleDbCommand ocm = new OleDbCommand(sql, objConn);
ocm.ExecuteNonQuery();
objConn.Close();
其实操作ACCESS和SQL Server都差不多 只是开都不一样和申明的空间名不一样
ACCESS的是OleDb开头的