General Error messages in SQL SERVER

1. How to enable OPENROWSET in SQL SERVER?
2. Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.
3. The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.