locked
How do I get Microsoft Access data into my workbooks on Excel Services? RRS feed

  • Question

  • Hi,

      I have requirement to populate access data to excel and shown into excel service.

    could any body please provide me the correct steps to be followed up.

    please note that we need to follow the steps on production server.

    Regards

    Patil

    Wednesday, February 1, 2012 11:50 AM

Answers

  •  

    Hi Patil,

    Workbooks that refresh data from an Access database are not supported with the features that come with Excel Services. This is because these types of solutions have problems scaling and performing in an enterprise server environment. Although it might be possible to make this work by adding the right provider to the trusted providers list and installing any required Data Source Name (DSN) files on the server, it is not supported.

    For more information, please check this:

    http://technet.microsoft.com/en-us/library/cc262899(office.12).aspx

    Thanks.


    Pengyu Zhao

    TechNet Community Support

    • Marked as answer by Pengyu Zhao Friday, February 10, 2012 9:17 AM
    Wednesday, February 8, 2012 7:06 AM

All replies

  • Please confirm that these are Excel Services that are part of MOSS 2007 Enterprise Edition.
    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Wednesday, February 1, 2012 8:53 PM
  •  

    Hi Patil,

    Workbooks that refresh data from an Access database are not supported with the features that come with Excel Services. This is because these types of solutions have problems scaling and performing in an enterprise server environment. Although it might be possible to make this work by adding the right provider to the trusted providers list and installing any required Data Source Name (DSN) files on the server, it is not supported.

    For more information, please check this:

    http://technet.microsoft.com/en-us/library/cc262899(office.12).aspx

    Thanks.


    Pengyu Zhao

    TechNet Community Support

    • Marked as answer by Pengyu Zhao Friday, February 10, 2012 9:17 AM
    Wednesday, February 8, 2012 7:06 AM