Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Display data in Sharepoint list from query

Posted on 2011-02-15
Last Modified: 2012-05-11
I have created a custom Sharepoint List that display data from a query I ran again another database, I copied the results into the list. I want to know if its possible to have this list populated somehow by executing the query in sharepoint? if so , how?
Question by:tips54
  • 3
  • 3
  • 2

Expert Comment

ID: 34898207
There is several ways that you can do this.  One big question though I would like to have answered.  What version of SharePoint are we refering to?  WSS 3.0, MOSS 2007, SharePoint Foundation, or SharePoint Server 2010?

Author Comment

ID: 34898631
I'm on WSS 3.0

Expert Comment

ID: 34898896
Terriffic.  As you know working with a free software, in this case WSS 3.0 the solution is rarely as easy as one would like.  Here are your options.

1. Upgrade Your Environment

One thing you can do is upgrade your WSS 3.0 Environment to SharePoint Foundation 2010 (read this as WSS 4.0).  The reason I suggest this is because you get the BCS  (Business Connectivity Service) with this version.  Shocking but so very cool, is the fact they have the BCS as this free version.  If you wish to know more, please visit: http://msdn.microsoft.com/en-us/library/ee534979.aspx

2. Excel then Manual Process

The second is use the abilites of Excel data connectors to tie to your database then manually copy and pasted the new information into the list you created.  This way is much less ideal, but will cost you no money. (Maybe a bit of aggrivation)  At least you can keep the Excel Spreadsheet in a document library held on the same site.

3. 3rd Party Software

There are 3rd party solutions out there as well.  Stonebond is certainly the first that comes to mind in this.  Their software is embedded in SharePoint 2010 and probably the reason why it is a part of the free version. (see Step 1)

4. InfoPath is your friend

Like Microsoft Excel, InfoPath can connect to data sources as well.  How you go about drawing the data out is a different story.  Do you 1 create an InfoPath form tied to the data using a drop down box to create a individual form for each item in the view?  (This is a pretty solid say of handling it, if there is just a few items or you have a lot of patience.  Not suggestable over 1900 items unless you also put them in a folders a layer deep)  The other way of dealing with it, is with use of the repeating tables and such.  This can be another way, but it will be in one form and may not be the results you are looking for. (Definatly not a good idea if there is a lot of items due to the fact all the information is downloaded at the time the Form is opened.  You could have a Form take a good couple minutes to render because of the amount of data being pulled down.
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34899008
why not use Data View web part.


with DVWP, you can display (or modify) data from another source, such as sql.  it is displayed in list view, like any other sharepoint list.  but the source can be something outside of sharepoint.

so, you'd configure DVWP to run your query, and display the data in sharepoint.

Author Comment

ID: 34899082
I used the Excel method prior to posting this question and I was hoping for something better. number 4 touch on my main issue, which is this List I'm creating right now has 6800 items listed in it,  and I'm referencing this List in another to do a Lookup type of field. I have 3 list that is like that and I want to reduce having these long list (several thousands of SKU's).  None of 1 through 4 sound solid without doing some sort of upgrade , even that's not guaranteed.   We use sharepoint heavily here, I don't want to bug down the server more than it already is. your  thoughts?

Accepted Solution

djpileggi earned 125 total points
ID: 34899278
Got to love SharePoint, it is the Swiss Army Knife of applications.

I definatly see your dilema here.  You have a lot of data you are trying to bring into your enviornment AND it is desired to use in more than one place in the SharePoint farm.  In all honesty, your best bet is #1.  With the addition of the Business Connectivity service you will be able to build it to the data source once, and turn around and use it in as many locations as you wish.  If this is an option, I highly recommend going with it.  If you cannot, this is what you need to do.  Go ahead, and put it in a single list at the root level.  Go into list administration and make sure you uncheck the option of having the list indexed for search.  This will allow you to do it.  It will render slowly, but at least it will work and not kill your indexer. This way is far from ideal, but will work somewhat effectively.
LVL 43

Assisted Solution

by:zephyr_hex (Megan)
zephyr_hex (Megan) earned 125 total points
ID: 34908084
once again...
DATA VIEW WEB PART will do what you want.

Author Closing Comment

ID: 35027129
I ended copying the data in there, but I definitely try the data view soon

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
JavaScript waiting 14 84
Moving SharePoint 3.0 role to differen server 7 68
SharePoint 2013 Relational Database 8 117
SharePoint Calculated Field or Workflow to Substring 17 61
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question