On my list the datasheet button is greyed out. How do I go about enabling it?
As SPDoctor stated - it sounds like an issue with 64 bit install of Office. You cannot view a list in Datasheet view after you install the 64-bit version of Office 2010
Try installing the 2007 Office System Driver: Data Connectivity Components