I understand the SPGridview control now, but how do I enable the spgridview (or another control) to behave and function like the access control when in datasheet mode?
You can't. Datasheet mode is an ActiveX control. It is completely separate from the SPGridView.
AFAIK, you can't use the datasheet activex control in your customizations and you can't customize the control itself.