Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Word or Excel file to pull data from SQL DB

  Asked By: Deepak    Date: Aug 24    Category: Sharepoint    Views: 3022

I have two questions: 1) Is it possible to create a word or excel file
to pull data from an SQL DB an show it on a sharepoint site? 2) Are
there any form makers (ie. draw text boxes, field boxes etc) for
sharepoint or can this be done in sharepoint designer?

I'm just trying to get ideas of what I can and cannot do.



3 Answers Found

Answer #1    Answered By: Tricia Mullins     Answered On: Aug 24

If you want to create  a form  that will pull  data from a SQL backend data
store, I would suggest that you look at InfoPath from Microsoft. Mix this
with SharePoint's forms services and you have a nice solution for your
users. Form Services allows users to fill out an InfoPath form in the
browser, without the need to have InfoPath installed on their workstation.

Answer #2    Answered By: Himanshu Gohil     Answered On: Aug 24

To answer the first question: yes, you can access SQL data  from Excel
and Word. Those could be in document libraries in SharePoint.
However, if what you really want to do is display a form  which gets
data from a SQL db, then you should go the InfoPath route.

Answer #3    Answered By: Ashton Schroeder     Answered On: Aug 24

One other view-only option if you don't want to go the InfoPath route is
the Data View/Data form  Web Part. Pretty easy to create  and format in
SharePoint Designer 2007 or FrontPage 2003 (depending on what version of
SharePoint you are running). With 2007 it can be read/write, but it's a
lot trickier to implement, so unless the licensing cost is a major
hurdle I'd go with InfoPath there.

Didn't find what you were looking for? Find more on Word or Excel file to pull data from SQL DB Or get search suggestion and latest updates.