locked
Import excel to sharepoint, and the imported file data may get copied to ms-access RRS feed

  • Question

  • Basically, I'm trying to create a Reporting Tool that will generate a report from multiple
    Excel files (these Excel files are uploaded in a Sharepoint list).
    I want that the the data may get pulled
    these files and get copies into an MS Access Database file where the Reporting Tool will get the data for its report.

     

    Wednesday, August 8, 2012 10:44 AM

All replies

  • Hello Ananya,

    Try following steps

    • Create a blank database in MS Access
    • Open the excel file uploaded to SharePoint Doc Lib
    • From the Excel toolbar, choose Data tab
    • Then click on connections > add
    • Add the access file location to that window and click ok
    • Now the changes made on excel file will be automatically stored in Access DB

    Or

    • Convert your Excel data to XML
    • Then from MS Access, choose import Excel option under External Data tab
    • This will allow you to import xml file from intranet / internet / ftp url

    Please let us know if this helps



    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights

    Wednesday, August 8, 2012 9:15 PM
  • Hi,

    For the first option,

    do we have to do this for every excel file which will be uploaded by the user?

    Thursday, August 9, 2012 5:23 AM