I have a SharePoint 2013 list that I have linked to MS Access. When I try to sort the table by the file name, the option to sort A ---> Z is grayed out. What is the limitation that I am running into? How may I get around it?
Big picture: I am working to migrate a Document Library from SharePoint 2007 to SharePoint 2013. I have created a Document library in 2013 to mirror the Library in 2007. I have moved the files between the servers (4,397 of them). Now I wish to move the associated column data from 2007 to 2013. I had hoped to simply copy and paste in datasheet view (2007), but the Quick Edit view (2013) does not allow me to view the whole library at once. The work around was to link the 2013 Document Library to Access and copy and paste from the 2007 Data View to the 2013 Access linked table. I cannot sort the Access table to bring it into alignment with my 2007 Document Library in Data Sheet view.