>string AccessConnString = @"Provider=Microoft.Jet.OLEDB.4.0;Data Source=C:\Projects\Sales Quote\Database\Orig\quotedb 9-27.mdb"; >OleDbConnection AccessConn = new OleDbConnection(); >AccessConn.ConnectionString = AccessConnString; > >try >{ > AccessConn.Open(); >} >catch (Exception e) >{ > throw e; >} > >OleDbCommand oCommand = new OleDbCommand(); >oCommand.CommandText = "select * from vendors"; >oCommand.Connection = AccessConn; > >OleDbDataAdapter AccessDA = new OleDbDataAdapter(); >AccessDA.SelectCommand = oCommand; > >DataSet dsAccess = new DataSet(); >AccessDA.Fill(dsAccess, "Vendors"); > >>