Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SharePoint as Data Source for Excel

  Asked By: Keaton    Date: Jul 19    Category: Sharepoint    Views: 10824

In Excel, I can import external data from

Data | Import External Data | Import Data | New Source

Where you get the Data Connection Wizard.

One option there is "Microsoft Business Solutions" where you'll get
a dialog box that says:

Type the computer name or URL where the data retrieval service is
located. Typically a data retrieval service is located on a server
running Microsoft Windows SharePoint Services 2.0.

So I enter the URL of my portal:


and I get this error:

The appropriate data retrieval service could not be found at the
floowing URL: http://myportal/_vti_bin/dspmbs.asmx. Reenter the URL
or comuter name for the server and try your request again.

Where do I get one of these dspmbs.asmx things?



2 Answers Found

Answer #1    Answered By: Harshita Padwal     Answered On: Jul 19

I've never tried to do this but FWIW, I have a dsbmbs.asmx file in the
ISAPI folder of my "60 hive".

Answer #2    Answered By: Jennifer Jones     Answered On: Jul 19

Do you suppose that the dsbmbs.asmx is installed with WSS or have
you added some other spice to the mix?

I have a vanilla SPS install and no dsbmbs.asms.

Didn't find what you were looking for? Find more on SharePoint as Data Source for Excel Or get search suggestion and latest updates.