// PASTE THIS CODE INTO YOUR MAIN PROGRAM string dbstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\jpv\Desktop\greatart.mdb"; string sql = "SELECT * FROM art"; // connection object OleDbConnection conn = new OleDbConnection(dbstr); conn.Open(); // command object passing sql command and connection OleDbCommand command = new OleDbCommand(sql, conn); // reader object receiving results of SQL execution OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { String title = (string)reader["Title"]; String medium = (string)reader["Medium"]; Console.WriteLine("{0} -> {1}", title, medium); } Console.ReadLine(); reader.Close(); conn.Close();