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
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
  • 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:

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.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

688 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