Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

sql database to Sharepont list

  Asked By: Stacey    Date: Apr 08    Category: Sharepoint    Views: 1926

I am looking for methodology to populate a list from a sql database...???

Anyone know if such a task accomplished...



2 Answers Found

Answer #1    Answered By: Schuyler Le     Answered On: Apr 08

Is this a one time transfer of data? or is it an ongoing process to keep the
database and list  in sync?

There are several ways to get data into a list that don't require a lot of work

You can use Excel to pull all the fields from the database  into a worksheet and
then import the worksheet into a new list.

You can also use Access to connect to both the SharePoint List and then SQL and
run a query which will populate  the list from SQL data. This might be helpful
if the data transfer is going to happen more than once.

Answer #2    Answered By: Kristina Cox     Answered On: Apr 08

You can literally write to the database  using sql  or the ObjectModel. You
could also add a dataview webpart with frontpage and populate  the list  from
query or webservice.

Walk-Through: Creating a Data View of Data from a Database

This section describes how to create a data view from your database.

1. In FrontPage, on the *Insert* menu, click *Database*, and then
click *Data View*. This opens the *Data Source Catalog* task  pane.

*Note* You can also add a new database connection from the *Data
Source Catalog* task pane. Alternatively, you can click *Data*. . .*Insert
Data View* to launch the Data Source Catalog as well

2. Configure the connection. For example, you can add a filter,
specify sort order, identify fields to show or hide.
3. Now, you can create a connection to the database. If you already
have a connection, it appears in the *Data Source Catalog *list.
Otherwise, in the Database Connections section, click *Add to
Catalog*and add a new connection.
4. Once you add the data source to the *Data Source Catalog* list,
drag and drop the Data Source onto the page wherever you want the data view
to appear. In addition, the FrontPage Design View even shows the data in the
Data View Web Part while you edit the page.

Full article here -

Web Service Article


Didn't find what you were looking for? Find more on sql database to Sharepont list Or get search suggestion and latest updates.